Re: Query to measure memory usage by subpool ?

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 30 Jun 2007 21:43:48 +0200
Message-ID: <6e9345580706301243t72568a0bie8efe10de74eec11@mail.gmail.com>

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_at_gmail.com> 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_at_rogers.com

>

> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>


--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jun 30 2007 - 14:43:48 CDT