parsed.org

Tips by tag: v$session

List Connected Users in Oracle by xinu on Dec 31, 2007 10:05 AM

Run the following query:

SELECT s.username, s.program, s.logon_time
FROM v$session s, v$process p, sys.v_$sess_io si
WHERE s.paddr = p.addr(+)
AND si.sid(+) = s.sid
AND s.type = 'USER';
connectionsoraclesqlplussystemv$processv$session
RSS