Monthly Archives: January 2013

Native PLSQL Execution

Native PLSQL execution has changed significantly since the version 10G. The effects are less than spectacular, in the ideal case I got about 10% of the performance boost. This is much easier to administer now, there are no shared libraries … Continue reading

Posted in Miscellaneous Oracle | Tagged , , | 3 Comments

Native Compilation and TRCA

Carlos Sierra of Oracle Corp.┬á created a very useful tool called TRCA, intended for analyzing Oracle trace files, much like tkprof. The tool is written entirely in PL/SQL, so there is no command line interface distributed with the tool. It … Continue reading

Posted in Miscellaneous Oracle | Tagged , , , | 1 Comment