ORA-4031 On ASM Instances With High SQLA and Procwatcher is Running
(Doc ID 1454936.1)
Last updated on AUGUST 02, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
This issue was observed on Oracle 22.214.171.124 64-bit on a Linux x86_64 server, on a ASM Instance, part of a RAC cluster.
shared_pool_size = 200M
large_pool_size = 80M
instance_type = "asm"
sga_target = 500M
db_cache_size = 128M
1) An example of the complete error message reported in ASM alert.log file was:
2) The trace file shows a single subpool where the largest memory consumer is the SQLA area.
"SQLA " 53112128
"KGLH0 " 23993336
"ASH buffers " 14680064
. . . . .
3) The trace file shows the last wait event was: 'SGA: allocation forcing component growth'.
4) Another symptom was the continuous growth of the SQLA area in the shared pool.
This can be determined by taking regular samples as follows:
6) The SQL area may show SQL statements like the following:
select 'PROC '||p.spid||' - '| . . . . . .
select 'PROC '||spid PROC, ash . . . . . .
Procwather was started.
Procwatcher is a tool to examine and monitor Oracle database and/or clusterware processes at an interval. It is found in <Note 459694.1>
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