Is there a way to identify which Sequences are currently loaded into the Shared Pool ? {how much memory does a sequences take ?} I need to periodically "poll" the Shared Pool and identify the most frequently used sequences. {I guess if I periodically query DBA_SEQUENCES, I could get the LAST_NUMBER but I'd have to maintain a "history" table and verify the previously fetched LAST_NUMBER} 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------