ORA-04031 on ASM Instances when Shareplex is used.

(Doc ID 1502764.1)

Last updated on AUGUST 06, 2013

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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 , however most of the reported cases are on

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

hdl number;
blk_num number;
bytes number;
hdl := 2;
blk_num := 326944;
bytes := 32256;

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



 Upgraded the Grid Infrastructure to



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