DBMS_SCHEDULER.DROP_JOB Executed in a Loop Is Leaking PGA Memory

(Doc ID 1324675.1)

Last updated on DECEMBER 13, 2011

In this Document


When executing in a PL/SQL loop one of the DBMS_SCHEDULER procedures:
the PGA memory of the process doing the procedure will increase constantly in time.

A heapdump of the pga will show memory leaked in callheap of type "perm"
CPRM Chunks "kqlidpc"


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