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

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2009

Added on Nov 5 2009

#11g, #9i, #general-database-discussions

16 comments

14,997 views