tkprof table
Hi all,
we have ORACLE 11.2.0.1 Linux RHE 5.4 x64 siebel 8.1 test environment.
Recently I did trace level 12 for entire DB, siebel have been upgraded, then trace level 12 again.
all of that to compare performance before and after the upgrade of siebel.
I've done tkprof with insert=xx.sql, and inserted all the output data into two table to compare queries, made hash value for each statement with dbms_crypto.hash
now that I've filtered some data I see that in exe_disk column there are usually 2 values - 0 or 140733193388032
I've also checked - the value comes within the insert statement, that tkprof generates.
we have ORACLE 11.2.0.1 Linux RHE 5.4 x64 siebel 8.1 test environment.
Recently I did trace level 12 for entire DB, siebel have been upgraded, then trace level 12 again.
all of that to compare performance before and after the upgrade of siebel.
I've done tkprof with insert=xx.sql, and inserted all the output data into two table to compare queries, made hash value for each statement with dbms_crypto.hash
now that I've filtered some data I see that in exe_disk column there are usually 2 values - 0 or 140733193388032
I've also checked - the value comes within the insert statement, that tkprof generates.
0