My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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