Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to optimize query's execution?

Re: How to optimize query's execution?

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 30 Aug 2005 07:18:52 -0700
Message-ID: <1125411532.313621.17610@g14g2000cwa.googlegroups.com>


The explain plan you posted does not really help. You need to actually run the query and gather information using extended sql_trace (do a search on sql_trace binds waits). Run the resulting output through tkprof with waits=yes sys=no. This will tell you what actually happened.

If you suspect that there might be a problem with the optimizer or statistics, compare the tkprof output with the output from an explain plan with the cardinality estimates. If the rows in tkprof and the cardinality estimates from the explain plan are not similar (don't expect them to be exact), you have to address the reason.

I know that this response does not provide you the answer you are looking for, but it provides you enough clues to locate the problem yourself with some research. Received on Tue Aug 30 2005 - 09:18:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US