ORA-04031 Errors Raised on Instance That Also Has Many ORA-923 Parse Errors (Doc ID 2589688.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Many ORA-04031 'unable to allocate xx bytes of shared memory' errors are signaled. The alert log also shows many parse error messages similar to the following

2019-07-22T03:59:56.338823-04:00
DMID5T03(11):WARNING: too many parse errors, count=338800 SQL hash=0x8a6d572b
DMID5T03(11):PARSE ERROR: ospid=234865, error=923 for statement:
2019-07-22T03:59:56.338965-04:00
DMID5T03(11):select 0
DMID5T03(11):Additional information: hd=0x847b89230 phd=0x847b8a658 flg=0x28 cisid=388 sid=388 ciuid=388 uid=388

This shows many parse errors on a multitenant PDB (almost 339 thousand). The error is 'ORA-00923: FROM keyword not found where expected '. The SQL for the case shown above is 'select 0'.

Changes

Cause

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