Originally posted by mrvajrala
select * from v$session
where sid= (Select distinct sid from v$mystat);
pretty costy query to get your sid