RE: Shared_pool

Jos,

select value from v$parameter where name='shared_pool_size' will tell you the size of the shared pool;

select * from v$sgastat where name like '%free%' and pool like '%shared%'
will tell you how is free.

Then you can calculate the percentage free.

Hope this helps.

Govind

-----Original Message-----
Sent: Wednesday, November 06, 2002 8:43 PM To: Multiple recipients of list ORACLE-L

On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote:
>
> List,
>
> How do I find out how full my shared_pool is?

-- 

 Diagnosing and Resolving Error ORA-04031 
 Type: Note Doc ID: 146599.1 

 Understanding and Tuning the Shared Pool in Oracle7, Oracle8, and
Oracle8i 
 Type: Note Doc ID: 62143.1 


good reading!
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

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: 
  INET: Govind.Arumugam_at_alltel.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).