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