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_at_gmail.com> wrote:
>
> 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:51:29 CDT
