Re: When does a SQL stmt enter V$SQL

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 22 Nov 2005 16:03:49 +0000 (UTC)
Message-ID: <dlvfh5$c01$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>

The plan should go into v$sql_plan as soon as the query has been optimized. But a plan can be dumped when there is a demand for memory; even when the cursor that owns it is still in memory.

If this is happening regularly, and the cursors are then being re-optimized, you should see the 'reloads' counter in v$librarycache increasing steadily.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Nov 2005

"Spendius" <spendius_at_muchomail.com> wrote in message 
news:1132672828.510537.279760_at_f14g2000cwb.googlegroups.com...


> Hello,

> I've been trying to find several hash_values found in V$SQL[AREA]

> in V$SQL_PLAN but to no avail (also tried with the ADDRESS)...

> What makes a query enter the V$SQL_PLAN view ?

> (I'm talking about 9i)

>

> Thanks.

> Sp

>

Received on Tue Nov 22 2005 - 10:03:49 CST

Re: When does a SQL stmt enter V$SQL_PLAN ?