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
  Symptoms
  Cause
  Solution


Symptoms

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"

Cause

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