Article # is 396940.1
It does not show breakdown by subpool, only overall memory usage.
On 6/30/07, LS Cheng <exriscer_at_gmail.com> 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_at_gmail.com> 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_at_rogers.com
> >
> http://ca.geocities.com/mosicr@rogers.com/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_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jun 30 2007 - 15:27:33 CDT
