Re: Query to measure memory usage by subpool ?

Ranko Mosic schrieb:

>> From 9i and on shared pool is broken down into subpools.

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