-
When we are killing a user session, we use SID,SERIAL#. For any session, the SID is unique( I hope I'm not wrong). Then what is the need of using SERIAL# in ALTER SYSTEM KILL command?
-
Why do you have to specify END IF instead of just END at the end of an IF statment. Because that's the way it is.
Jeff Hunter
-
alter system kill session 'sid,serial#';
-
I think Jeff got very angry(kidding). I know that thats the way it is, but I wanted to know if it has any significance when killing a session, like does it refer to any OS resources.
-
I have issues. I can't help it.
No, Serial# is not related to any system resources like Process ID. See http://download-west.oracle.com/otnd...157.htm#991798 for details...
Jeff Hunter
-
In my opinion, its a double surety to ensure you don't kill the wrong session by mistake.
-
A single session (SID) can have many serial#.
Especially if you are working in a distributed env and ODBC connectivities.
That is why you are required to specify both.
svk
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|