SET LINESIZE 200 SET PAGESIZE 66 SELECT s.username, s.logon_time, s.machine, s.osuser, s.program 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';
All things relative to everyday programming and DBA practices, This blog will not give you the ET staff, just little remindings about how things work. Subjects are relative to databases, programming, Linux, Windows and ... you name it. I used to have a notepad onto which I put down anything I thought I might need again. Hopefully this is going to be as good as the paper with the added value of being able to paste from.
Thursday, 8 February 2007
Oracle 10g SQL Script to list the connected users
OK, I know that EM can give you the same result in much prettier form, but let's keep that just in case.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment