EM13c: SQL ID '747d8puab2h4u' Consuming High Resources in Repository Database (Doc ID 2645649.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Symptoms

The following SQL ID is seen as high resource consumer in the repository database:

SQL ID - 747d8puab2h4u

BEGIN DBMS_APPLICATION_INFO.SET_ACTION(:1 );
  EM_LOADERJOB.dequeu_job(:2 ,:3 ,:4 ,:5 ,:6 ,:7 ); END;

Also seen as high resource consumer is:

SQL ID - 65x06n09f0v45

29k gets per execution are seen for SQL ID 65x06n09f0v45 (top level caller for SQL ID - 747d8puab2h4u) in the AWR report during the time of the issue.

Buffer Gets Executions Gets per Exec %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
1,252,797,044 42,281 29,630.26 36.75 9,349.74 77.8 0 65x06n09f0v45 OEM.PbsSystemPool select /*+ first_rows(1) no_ex...

Cause

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