RE: A VLDB contest

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Wed, 30 Aug 2006 09:22:47 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AE80@ex2.ms.polyserve.com>

>>>
>>>...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

Received on Wed Aug 30 2006 - 11:22:47 CDT