RE: A VLDB contest

 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.

--
http://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
==============================================================================

--
http://www.freelists.org/webpage/oracle-l

Other related posts: