serial# and SID
661723Nov 5 2009 — edited Nov 15 2009hi!!!
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?