Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

serial# and SID

661723Nov 5 2009 — edited Nov 15 2009
hi!!!

I am a DBA funa-1 9i WDP student.I need some help:

(If i am not wrong)v$session is dynamic view which store some information about oracle.but my question is why serial# and SID is required to kill the session??why not just only SID to kill the session??

another thing is that a user can use multiple session(as oracle does not restrict to do so).we observed there is a unique-ness for Serial# then why do we need to mention SID to kill the session?
And my final question is, how the SID and Serial# is generated?
This post has been answered by 722357 on Nov 13 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2009
Added on Nov 5 2009
16 comments
14,882 views