Oracle PL/SQL – Quantify Code Performance For Comparison Of Different Approaches – Tom Kyte’s “runstats”

Is my PL/SQL code going to perform better? I have rewritten my Oracle code. Now, how do I tell if my coding approach A is better than coding approach B? If someone were to ask you the above question, typically, you would give the following answers If one approach is faster than the other, that … Continue reading Oracle PL/SQL – Quantify Code Performance For Comparison Of Different Approaches – Tom Kyte’s “runstats”

Advertisements

Oracle: Using Oracle Trace from code without “tkprof” – The basics

Update: Although it is still relevant today, this was originally written in Aug 2012. A lot of times, in your PL/SQL application, you might run into an error but do not know what statement caused the error. The program might lack any form of outputting (to UTL folder, log tables or otherwise). The simplest way … Continue reading Oracle: Using Oracle Trace from code without “tkprof” – The basics