Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
10 lines (9 sloc) 281 Bytes
set line 132
col username for a15
col schemaname for a15
SELECT s.username, s.user#, s.sid, s.serial#, s.prev_hash_value, schemaname, p.spid os_pid
FROM V$SESSION S, v$process p
WHERE audsid = SYS_CONTEXT('userenv','sessionid')
and p.addr = s.paddr
and s.username is not null
/