User session id

[haste]

How do I get a sessions session id (sid). I have tried using the following:

SELECT sys_context('USERENV','SID') 
FROM DUAL

but got nothing. Had initally opened 2 sessions with the same user, of which I wanted to trace one of them using the set_sql_trace_in_session procedure. Using

select username, sid, serial#, command 
from v$session;

I could get identify them by username but I dint know which session was which.

 

[KenCunningham]

Not sure, but I think if the command column shows 3, that is the user issuing the select statement.

 

[haste]

Think u have a point there. Did some googling n got this:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:114412348062

You use the ausid field of v$session and the userenv fucntion as below

select * from v$session where audsid=userenv('sessionid');

Thanx for the input.