A VLDB contest

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Tue, 29 Aug 2006 16:23:47 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AE6D@ex2.ms.polyserve.com>

Does anyone actually have ASM "put to the test" as they say? Anyone have huge ASM extent pointer array areas within their shared pool? Anyone
have "ORA-4031-creeping syndrome" ?

For instance:

         select * from v$sgastat;
POOL         NAME                            BYTES


------------ -------------------------- ----------

 shared pool ASM extent pointer array 287097144

Anyone see 1GB or more?

Kevin Closson
Chief Architect, Oracle Database Solutions PolyServe, Inc
kevinc_at_polyserve.com
http://www.polyserve.com/oracle_consolidation.php http://www.polyserve.com/oracle_rac_clusters.php

--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 29 2006 - 18:23:47 CDT