Re: Query to measure memory usage by subpool ?
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: ranko.mosic@xxxxxxxxx
- Date: Sat, 30 Jun 2007 21:43:48 +0200
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
- Follow-Ups:
- Re: Query to measure memory usage by subpool ?
- From: Ranko Mosic
- References:
- Query to measure memory usage by subpool ?
- From: Ranko Mosic
Other related posts:
- » Query to measure memory usage by subpool ?
- » Re: Query to measure memory usage by subpool ?
- » Re: Query to measure memory usage by subpool ?
- » Re: Query to measure memory usage by subpool ?
- » Re: Query to measure memory usage by subpool ?
- » Re: Query to measure memory usage by subpool ?
- » Re: Query to measure memory usage by subpool ?
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
- Re: Query to measure memory usage by subpool ?
- From: Ranko Mosic
- Query to measure memory usage by subpool ?
- From: Ranko Mosic