PGA Memory Leak Is Observed When DBMS_SQL.PARSE Is Invoked with 'Container' Parameter (Doc ID 2704405.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

The consumption of PGA memory increases rapidly when the procedure DBMS_SQL.PARSE is executed along with the parameter 'container' in an infinite loop. The memory consumption goes back to the initial value instantly as soon as the code is forcibly terminated. However, no such increase is observed when the same call is made without passing the parameter 'container'. The issue can be demonstrated using the following sample code.

Session 1 :-
------------

Changes

The code is executed for the first time in the database.

Cause

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