RE: A VLDB contest
- From: "Lawie, Duncan" <duncan.lawie@xxxxxxxxxxxxxxxxx>
- To: "'kevinc@xxxxxxxxxxxxx'" <kevinc@xxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Aug 2006 17:40:47 +0100
I know it shouldn't be larger than that, but I've seen shared pool
miscellaneous grow to values bigger than my physical memory (on 9205) so I'm
perfectly prepared to accept an accounting error here.
Unless v$sga is lying to me, the apparent value for ASM extent pointer array is
bigger than my SGA.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Kevin Closson
Sent: 30 August 2006 17:23
To: ORACLE-L
Subject: RE: A VLDB contest
>>>
>>>...can't be bigger than your SGA since it is a component of the
>>>shared pool. You must mean larger than your buffer pool..and bingo,
>>>now the lights are comping on :-)
Hold it, I made the speed-reading mistake here. Your queries of gv$sgastat
threw me. The extent array is in the shared pool so it can't be larger than
that.
--
//www.freelists.org/webpage/oracle-l
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
