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