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: 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

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
  Symptoms
  Cause
  Solution
  References

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.