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 22.214.171.124 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.
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 126.96.36.199 , however most of the reported cases are on 188.8.131.52)
2 Shared Pool is fragmented with SQLs similar to the following .
hdl := 2;
blk_num := 326944;
bytes := 32256;
3 Shareplex ( a third party monitoring product) is in use.
Upgraded the Grid Infrastructure to 184.108.40.206
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