My SID Session

[tamilselvan]

select sid, serial# , username from v$session
where username = 'yourname';