find out what SID and SERIAL# i am 10g when i connect
is there a simple way for me to know what
sid / serial # i am when i connect to oracle.
Currently The same user id will connect a few times and will connect using the same program
I am really trying to find out if I can get the information from sys.v_$session, but i want it for the session I am currently connected to.
I was going to record this information in a log, so that if I have an issue with a process that was developed, I would be able to quickly look for the SID and Serial# to use the ALTER SYSTEM KILL SESSION '$SID,&SERIAL' command.