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