My Oracle Support Banner

EM 13c : Agent High IO Usage Due To ha_backup Collections (Doc ID 2671066.1)

Last updated on MAY 16, 2020

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control, DBSNMP schema constantly executing jobs that are generating very high IO on a specific database target.

SQL_ID 6c6h85sywc8pg generates the following activity:

SQL_ID            INST    SNAP_ID    SNAP_TIME    Total Execs     Disk Reads     IO Waits      Iconn GB
------------- ---- ---------- -------------- ----------- ---------- ------------ --- ------------------- --- ------------
6c6h85sywc8pg   1        41761  20200421:10:00  13,201            126            151,653      1,780,894
6c6h85sywc8pg   1        41762  20200421:11:00  13,205            126            151,653      1,780,895
6c6h85sywc8pg   1        41763  20200421:12:00  13,209            126            151,653      1,780,895

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.