Database Administration (MOSC)

MOSC Banner

Idle time slowness after 19c upgrade

Hi All,

we recently upgraded DB from 11g R2 to 19c. After upgrade, we experience slowness issue in our work environment.

for ex:

1) Establish a SQL*Plus connection to the instance:

2) Leave this SQL session idle for an hour.

3) Return to the client and issue a simple select statement:

-- select * from v$tempfile; --> elapsed time is 46 seconds and the waitevent is "controlfile sequential read"

next execution is fast

after 5 minutes is fast

after 10 minutes is fast

wait another 1 hour additionally and it's slow again

Do anyone experience these type of issue, any input is appreciated.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center