Huge And Rising Value Of ''Asm Extent Pointer Array'' In V$Sgastat (Doc ID 390251.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.