Database Tuning (MOSC)

MOSC Banner

SQL ID 07yxy5atunm0f slow when selecting Performance>Advisors Home in OEM CC 13.4 on DB 12.2.0.1

edited Sep 19, 2020 5:00AM in Database Tuning (MOSC) 6 commentsAnswered

Hello All,

Above SQL ID is persistently slow on only 4 of our databases.  It appears to be Oracle delivered.

Is anyone else experiencing this similar slowness on same configuration?

We are running default Oracle init parms on 12.2.0.1 target DB

System, object, and fixed object stats are up-to-date.

We are running OEM 13.4 cc

We have a case open with Oracle they are still asking for information.

Issue appears to be similar to following bugs, however those are supposed to be 12.1 related.

Bug 19076456 : HIGH CONTROL FILE SEQUENTIAL READS WAITS WHILE ACCESSING THE ADVISOR HOMES IN OEM <===this was closed as duplicate to following bug

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center