My Oracle Support Banner

ORA-04031 on ASM Instances when Shareplex is used. (Doc ID 1502764.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

ORA-4031 can be due to several reasons. The issue descried in the document  would have the following specific symptoms.

1 ASM instances reporting ORA-04031 from shared pool  after  upgrade to 11.2(Not restricted to 11.2.0.3 , however most of the reported cases are on 11.2.0.3)

2 Shared Pool is fragmented with SQLs similar to the following .

DECLARE
hdl number;
blk_num number;
bytes number;
BEGIN
hdl := 2;
blk_num := 326944;
bytes := 32256;
BEGIN
dbms_diskgroup.read(hdl,blk_num,bytes,:data_ptr);

3 Shareplex ( a third party monitoring product) is in use.

 

Changes

 Upgraded the Grid Infrastructure to 11.2.0.3

 

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


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