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 > > -- > > //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