Re: Query tuning

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Tue, 8 Apr 2003 09:59:06 -0700
Message-ID: <sjDka.9$Hg1.132@news.oracle.com>

Tuning strategy might be different depending what oracle version you are in. If you are on 9.2, then the easiest way to tune is to capture execution statistics from V$SQL_PLAN_STATISTICS_ALL. Pay attention to the values in the following columns:

LAST_OUTPUT_ROWS
LAST_STARTS
LAST_CR_BUFFER_GETS

Sometimes it is quite easy to spot performance hot spots. For example you may see huge number of LAST_STARTS originating from some join node in the rowsource tree, then it becomes obvious that the join method must be changed from NL to HJ or SMJ. As a first step why don't you capture statistics and let the group know it in order to suggest some directions for query tuning?

<rajesh_at_solutionsoftware.com> wrote in message news:aa8abed4.0304072132.65cddb37_at_posting.google.com...
> Here is a query that I am executing in my application and it takes
> around 10 minutes to execute. Absolutely no idea how to proceed with
> fine tuning.
Received on Tue Apr 08 2003 - 11:59:06 CDT