OCI Database Management: high I/O Request and Database Time - SQL_ID bhnj3fq86kn57 on Table X$KTFBUE
(Doc ID 2978784.1)
Last updated on OCTOBER 12, 2023
Applies to:
OCI Database Management Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
While attempting to monitor a database target hosted on the OCI
The following query is consuming high I/O Request and high database time around 36 min
SQL_ID bhnj3fq86kn57,
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On The EM cloud Console ->on the Top activity page
2. The following query consume high database duration
3. SQL_ID bhnj3fq86kn57,
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 |
References |