Re: Query to measure memory usage by subpool ?

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) sizefrom x$ksmsp group by ksmchidx, ksmchcom, ksmchcls;

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


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

Follow-Ups:

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

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

Other related posts: