Re: Query to measure memory usage by subpool ?

Well just modify the query, you know the view and relevancolumns meanings
are documentated in the note...

Thanks

--
LSC



On 6/30/07, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote:


Article # is 396940.1
It does not show breakdown by subpool, only overall memory usage.

On 6/30/07, LS Cheng <exriscer@xxxxxxxxx> wrote:
> you can check 398940.1
>
> section "How much free memory is available in my SGA", there is a query
for
> your purpose
>
> Thanks
>
> --
> LSC
>
>
>
> On 6/30/07, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote:
> >
> > Hi,
> > From 9i and on shared pool is broken down into subpools.
> > I need query to find out free/used memory by subpool.
> >
> > --
> > 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
> > --
> > 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@xxxxxxxxxx

http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html

Other related posts: