14 November 2006

set autotrace traceonly

For those few of you out there more newb than even me, this can make a huge difference. Easy explanation of the power of AUTOTRACE in SQL*Plus, via Tom Kyte. Basically quick and easy way to get query plan and statistical data.

This is usually a sign that you need a better index:
880637 consistent gets
189017 physical reads

No comments:

Post a Comment