My Oracle Support Banner

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

Last updated on NOVEMBER 16, 2022

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


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

SQL ID - 747d8puab2h4u

  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...


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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