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 System & Session Wait Big Picture Analysis- Using RATIO_TO_REPORT Function

Numbers and meaning it comes to numbers, the easiest way to get a point across to majority of the people is to express something in terms of percentage. Let us consider an example where a query produces the “waits” Oracle experienced overall in terms of “Number of waits” and the “Time waited”. This produces: WAIT_CLASS … Continue reading Oracle System & Session Wait Big Picture Analysis- Using RATIO_TO_REPORT Function