My Oracle Support Banner

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 later
Information 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


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