RE: The life time of the data in v$sqlarea

From: Ravi Kulkarni <RKulkarni_at_rapidigm.com>
Date: Fri, 25 Oct 2002 09:49:13 -0800
Message-ID: <F001.004F3DE4.20021025094913@fatcity.com>

Chuan -
The Sqlarea should contain All the statements (generalized as objects here as it is true for sql stmts, cursors, procedures, sequences etc.) since the database startup WHICH are not yet flushed out of the LRU list UNLESS explicitly flushed through "..Flush shared_pool" command you mentioned. Also...

• Currently "pinned" ( accessed )objects will NOT be flushed (even with flush command)
• Objects "KEPT" using DBMS_SHARED_POOL.KEEP procedure to pin the objects to the Shared Pool for the life of the instance will NOT be flushed out of the Sqlarea, and hence cannot be seen thru the v$sqlarea.

Regards,
Ravi Kulkarni.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 10/25/02 1:13 AM

Dear All,

I wonder how long the life time of data in v$sqlarea. Is it a cumulative data collecting in v$sqlarea since last database startup?or do the data in v$sqlarea only reflect some recently data in Least Recetly List?

Why do I ask this is after I used "alter system flush shared_pool", I could not see some SQL statements in v$sqlarea where they were there before.

TIA Chuan

--

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

Author: Chuan Zhang
  INET: Chuan.Zhang_at_transact.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

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

Author: Ravi Kulkarni
  INET: RKulkarni_at_rapidigm.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 25 2002 - 12:49:13 CDT