Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Show Active Users From SQLPLus 1
- Thread starter Michael42
- Start date
-
1
- #2
SELECT s.sid,
s.serial#,
p.spid,
decode(s.osuser,'OraUser','*',null) thru_sqlnet,
s.username ora_uid,
s.osuser usr,
s.machine machine,
s.program apps,
io.block_gets + io.consistent_gets logical_reads,
io.physical_reads,
io.block_changes + io.consistent_changes logical_writes
FROM v$sess_io io,
v$process p,
v$session s
WHERE s.paddr = p.addr
AND s.sid = io.sid
AND s.TYPE = 'USER';
s.serial#,
p.spid,
decode(s.osuser,'OraUser','*',null) thru_sqlnet,
s.username ora_uid,
s.osuser usr,
s.machine machine,
s.program apps,
io.block_gets + io.consistent_gets logical_reads,
io.physical_reads,
io.block_changes + io.consistent_changes logical_writes
FROM v$sess_io io,
v$process p,
v$session s
WHERE s.paddr = p.addr
AND s.sid = io.sid
AND s.TYPE = 'USER';
- Thread starter
- #3
- Status