Re: Can we identify which sequences are currently loaded into the Shared Pool

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sun, 09 May 2004 19:32:53 +0800
Message-Id: <6.1.0.6.0.20040509193137.02436278@pop.singnet.com.sg>

Seem to have got this query working :
SQL> l

   1 select count(*), sum(sharable_mem)    2 from v$db_object_cache
   3 where (owner, name) in
   4* (select sequence_owner, sequence_name from dba_sequences)

{of course, I will use OWNER,NAME instead of COUNT(*) } Comments ?

Hemant
At 07:03 PM Sunday, I wrote:

>Is there a way to identify which Sequences are currently loaded into the
>Shared Pool ?
>{how much memory does a sequences take ?}
><deleted text>

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital

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 Sun May 09 2004 - 06:30:08 CDT