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: 10.2.0.2.0
This problem can occur on any platform.

Symptoms

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.
Eg:
SQL> select * from v$sgastat where name='ASM extent pointer array';

POOL NAME BYTES
------------ -------------------------- ------------
shared pool ASM extent pointer array 25444775448

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

Cause

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