Re: Query to measure memory usage by subpool ?

From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
To: "LS Cheng" <exriscer@xxxxxxxxx>
Date: Sat, 30 Jun 2007 13:27:33 -0700

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
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Query to measure memory usage by subpool ?
From: LS Cheng

References:
- Query to measure memory usage by subpool ?
  - From: Ranko Mosic
- Re: Query to measure memory usage by subpool ?
  - From: LS Cheng

Re: Query to measure memory usage by subpool ?

Other related posts: