---------------查看哪些用户连到了DB上，使用什么Program连接-----

SET LINESIZE 100

COLUMN spid FORMAT A10

COLUMN username FORMAT A10

COLUMN program FORMAT A45

SELECT s.sid, --Session identifier

s.serial#,–Session serial number. Used to uniquely identify a session’s objects.

p.spid, --Operating system process identifier

p.pid, --Oracle process identifier

s.username,–Oracle DB username

s.osuser,–Operating system client user name

s.TERMINAL,–Operating system terminal name

s.program,–Operating system program name

s.STATUS–Status of the session.ACTIVE,INACTIVE,KILLED,CACHED,SNIPED

FROM vsessions,v session s,vsessions,vprocess p

WHERE p.addr = s.paddr

AND s.type != ‘BACKGROUND’;