Huge And Rising Value Of ''Asm Extent Pointer Array'' In V$Sgastat

(Doc ID 390251.1)

Last updated on SEPTEMBER 20, 2006

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.


After the ASM and database instance have been running for some time, the
"ASM extent pointer array"
statistic from v$sgastat of the database instance is far larger than the whole SGA allocated.
SQL> select * from v$sgastat where name='ASM extent pointer array';

------------ -------------------------- ------------
shared pool ASM extent pointer array 25444775448

This can sometimes result in ORA-04031 errors and even to instance crashes.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms