Does anyone know what is the number order of serial# in the v$session?
E.s if i have users whith serial# =1 (what does it mean? are incremental the numbers?)
Printable View
Does anyone know what is the number order of serial# in the v$session?
E.s if i have users whith serial# =1 (what does it mean? are incremental the numbers?)
As far as I know it is a way to monitor that a user is active
If serial# is incrementing then the user is busy, if it does not move then it is possible that the user is inactive.
Cheers
Incorrect!
It is another session identified. Serial# makes sense only for sessions with AUDSID<>0 (actual database sessions but not internal Oracle processes.)
Good luck!
Sergey.