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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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