My Oracle Support Banner

EM 13c: EM processes using high cpu utilization on target DB (Doc ID 2785707.1)

Last updated on MAY 09, 2023

Applies to:

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

Symptoms

EM processes using high cpu utilization on target DB

AWR report collected against problematic DB target shows:

Section: SQL ordered by CPU Time

Problematic SQL

SQL Id
gnwc3naswu3p2

SQL Module
Oracle Enterprise Manager.Metric Engine

SQL Text
select rowid, inst#, bucket#, inst_lob#, max_seq#, flush_scn, flush_time, min_scn, min_time, max_scn, max_time, sid#, serial#, status, length(log_piece) from "CLI_SWP$3407ee5c$1$1" where flush_scn >= :1 and inst# = :2 order by flush_scn, inst_lob# asc

 

 

 

 

Cause

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


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