41 lines
1.1 KiB
SQL
41 lines
1.1 KiB
SQL
col u_username head USERNAME for a23
|
|
col u_sid head SID for a14
|
|
col u_spid head SPID for a14
|
|
col u_pid head OPID for 99999
|
|
col u_audsid head AUDSID for 9999999999
|
|
col u_osuser head OSUSER for a16 truncate
|
|
col u_machine head MACHINE for a18 truncate
|
|
col u_program head PROGRAM for a20 truncate
|
|
|
|
|
|
def usid_sql_hash_value=0
|
|
col usid_sql_hash_value head HASH_VALUE for 9999999999 new_value usid_sql_hash_value
|
|
|
|
select s.username u_username, ' ''' || s.sid || ',' || s.serial# || '''' u_sid,
|
|
s.audsid u_audsid,
|
|
s.osuser u_osuser,
|
|
substr(s.machine,instr(s.machine,'\')) u_machine,
|
|
-- s.action u_machine,
|
|
substr(s.program,instr(s.program,'('),20) u_program,
|
|
p.spid u_spid,
|
|
p.pid u_pid,
|
|
-- s.sql_address,
|
|
s.sql_hash_value usid_sql_hash_value,
|
|
s.last_call_et lastcall,
|
|
s.status,
|
|
s.saddr,
|
|
s.paddr,
|
|
s.taddr,
|
|
s.logon_time
|
|
from
|
|
v$session s,
|
|
v$process p
|
|
where
|
|
s.paddr=p.addr
|
|
and s.sid in (&1)
|
|
--and s.type!='BACKGROUND'
|
|
--and s.status='ACTIVE'
|
|
/
|
|
|
|
def 1=&usid_sql_hash_value
|
|
def 2=% |