Re[2]: How to compare two different SQL executions plans (question is more deeper then seams from first look)?
- From: Edgar Chupit <edgar.chupit@xxxxx>
- To: "J.Velikanovs@xxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Jun 2004 09:21:49 +0300
Hello J,
JVal> But for CPU utilization we can’t use LIOs statistics.
sure we can't, if it would be so simple, than optimizer wouldn't need
to compute cost of each query, but simply estimate lio count. I think
that you are trying to simplify things.
But for your questions, to get top sql's by cpu you need to sort by
cpu_time, but you have to remember, that you want to get top sql over
"problematic" period of time, who cares if "huge" query is running
off-hours? So you need to check queries that had been run when
critical business process was running.
For a second question, you may I think lio minimization rule still
apply, but developers should consider to compare estimated cost of
query and latches.
--
Best regards,
Edgar
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Re[2]: How to compare two different SQL executions plans (question is more deeper then seams from first look)?
