Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query to measure memory usage by subpool ?
Thanks guys, seems like this will do the trick.
On 6/30/07, Andreas Piesk <a.piesk_at_gmx.net> 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_at_rogers.com http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jun 30 2007 - 18:32:50 CDT
![]() |
![]() |