I know V$SESSION holds the SID info; but I have several sessions open for the User SCOTT; and I'm currently working on a particular session with some transaction. How can I find out what is the SID of this current session I am working on, assuming there is more than one SCOTT session open.
Can anyone pls tell me.