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.


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,

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,


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

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