Home » RDBMS Server » Server Administration » v$session
v$session [message #369225] Mon, 17 July 2000 15:14 Go to next message
Sitarama C Peruvel
Messages: 3
Registered: July 2000
Junior Member
Can anyone please tell me the importance of the column serial# in v$session view. I know that it is used for killing the session, but is there any other importance of that field? Thanks in advance
Re: v$session [message #369226 is a reply to message #369225] Tue, 18 July 2000 16:30 Go to previous message
Messages: 255
Registered: April 2000
Senior Member
Yes...it's for killing one session. It uniquely identifies one session. Some times session can be end and start with same sid, In this case the serial# will be an integer (usually 1/2/3/4) more than the previous one. You won't get the same sid and serial# again in an opened database until you shutdown it. There is some more about it connecting PMON, which I am not pretty sure.
Hope it helps
Previous Topic: Problem in a Select statement while using Database link
Next Topic: Dynamic triggers
Goto Forum:

Current Time: Tue May 28 00:20:41 CDT 2024