Re: Query to measure memory usage by subpool ?

From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
To: a.piesk@xxxxxxx
Date: Sat, 30 Jun 2007 16:32:50 -0700

Thanks guys, seems like this will do the trick.

On 6/30/07, Andreas Piesk <a.piesk@xxxxxxx> wrote:

Ranko Mosic schrieb:
>> From 9i and on shared pool is broken down into subpools.
> I need query to find out free/used memory by subpool.
>

you could query x$ksmsp:

select ksmchidx subpool, ksmchcom, ksmchcls status, sum(ksmchsiz) size
from x$ksmsp group by ksmchidx, ksmchcom, ksmchcls;


i think, metalink has some documents about shared pool and it's
subpools. search for "FAQ ORA-4031".

regards,
-ap
--
http://www.freelists.org/webpage/oracle-l



--
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
--
http://www.freelists.org/webpage/oracle-l

References:

Query to measure memory usage by subpool ?
From: Ranko Mosic

Re: Query to measure memory usage by subpool ?
From: Andreas Piesk

Re: Query to measure memory usage by subpool ?

Other related posts: