you can check 398940.1 section "How much free memory is available in my SGA", there is a query for your purpose Thanks -- LSC On 6/30/07, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote:
Hi, From 9i and on shared pool is broken down into subpools. I need query to find out free/used memory by subpool. -- Regards, Ranko Mosic Consultant Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785 email: mosicr@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html -- //www.freelists.org/webpage/oracle-l