11 lines
336 B
SQL
11 lines
336 B
SQL
select
|
|
prc.spid, ses.sid, ses.serial#, ses.machine, ses.osuser, to_char(ses.logon_time, 'DD/MM/YYYY HH24:MI') logon_time,
|
|
ses.last_call_et, ses.sql_id, ses.sql_trace, ses.sql_trace_binds, ses.sql_trace_waits, ses.sql_trace_plan_stats
|
|
from
|
|
v$process prc,
|
|
v$session ses
|
|
where
|
|
ses.paddr = prc.addr
|
|
and ses.sid = &sid
|
|
;
|