Re: Query to measure memory usage by subpool ?
- From: dimensional.dba@xxxxxxxxxxx
- To: a.piesk@xxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 30 Jun 2007 20:19:31 +0000
That FAQ has been replaced by the doc listed in the other email 396940.1
-------------- Original message --------------
From: Andreas Piesk <a.piesk@xxxxxxx>
> 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
>
>
Other related posts:
