You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query performance

in Database 3 comments

Hi Team,

We are currently investigating CPU spike issues and have reviewed the AWR report. Based on the report, the attached graph is ordered by CPU Time, and we would appreciate your guidance on whether the following SQL IDs can be further optimized:

1c1g86jhmbc5g
4ydcm84dfwm3a

When we examined these SQL statements, they appear to be simple SELECT queries. We have also verified that the underlying tables and indexes exist and appear to be in place. However, we are unsure whether we are overlooking any factors that could be contributing to the high CPU consumption.

Query:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!