current session's sid

  1. oracle sql for getting current session's trace file..
    select
    v$process.spid || nvl2(v$process.traceid, '_' || v$process.traceid, null ) || '.trc' "Trace File"
    ,v$session.audsid
    ,v$session.username
    ,v$session.sid
    from
    v$process
    join v$session on v$process.addr = v$session.paddr
    where
    v$session.sid=(select distinct sid from v$mystat);
    shan,24.03.2010 12:27,#740