A VLDB contest

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Aug 2006 16:23:47 -0700

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@xxxxxxxxxxxxx
http://www.polyserve.com/oracle_consolidation.php
http://www.polyserve.com/oracle_rac_clusters.php


Other related posts: