RE: How Reliable is Explain Plan in 9.2

[Post, Ethan]

Title: Message

Ahhhh, that is what he is talking about, I wasn't aware of v$sql_plan.

-----Original Message-----
From: Toepke, Kevin M [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How Reliable is Explain Plan in 9.2

As far as I can tell, the Explain Plan is 100% reliable. It shows how the query would execute if it was run from that session at that momement in time.

 

If you want to see how a query in the SGA actually ran, query the Oracle9i v$sql_plan view.

 

Kevin