Database Administration (MOSC)

MOSC Banner

v$session

edited Oct 17, 2023 11:06AM in Database Administration (MOSC) 1 commentAnswered

Hello Experts.


Environment:

AIX 7.2

Database Release Update : 19.20.0.0.230718 (35320081)

Question:

The query 'select LOGON_TIME,PREV_EXEC_START from v$session;'

returns something like:

Why could the 'LOGON_TIME' be recent than 'PREV_EXEC_START'?

Most of them have 'PREV_SQL_ID'='9zg9qd9bm4spu' which is: 'update user$...'

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