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