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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ((Re)): Really Wierd Query tuning issue

Re: ((Re)): Really Wierd Query tuning issue

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 13 Aug 2004 16:30:58 +0300
Message-ID: <059b01c48139$c54bba90$71849fd9@porgand>


> be sure about the plan or want the details by rowsource in the plan I use
> sqltrace and tkprof, or, increasingly, when using Oracle9, v$sql_plan and
> v$sql_plan_statistics.

Same here, but with relying on v$sql_plan in production environments, there's one potential threat, that if the statement gets invalidated or the execution plan aged out from shared pool for some reason, next user parsing the query might cause a different execution plan to be compiled...

Tanel.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Aug 13 2004 - 08:27:15 CDT

Original text of this message

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