RE: A VLDB contest

I don't have an 'ASM extent pointer array' at all in my ASM instance....  

  1 select * from v$sgastat
  2 where name like '%ASM%'
  3* order by bytes
SQL> /  

POOL         NAME                            BYTES
------------ -------------------------- ----------
shared pool  ASM rollback operations          2592
shared pool  ASM map operations               3360
shared pool  ASM db client                   11840
shared pool  ASM buffer object               37288
shared pool  ASM file                        75328

 
 

In my database instance that relies on ASM, however.....    

  1 select * from v$sgastat
  2 where name like '%ASM%'
  3* order by bytes
SQL> /  

POOL         NAME                            BYTES
------------ -------------------------- ----------
shared pool  ASM rollback operations          2592
shared pool  ASM map operations              16856
shared pool  ASM file                        19200
large pool   ASM map operations hashta      393216
shared pool  ASM extent pointer array      9527624

 

-Mark  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

Ours is the age that is proud of machines that can think and suspicious
of men who try to.  --H. Mumford Jones, 1892-1980

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Closson
Sent: Tuesday, August 29, 2006 7:24 PM
To: ORACLE-L
Subject: A VLDB contest




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

http://www.polyserve.com/oracle_rac_clusters.php


<http://www.polyserve.com/oracle_rac_clusters.php>  




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