查看连接到db的进程，程序名，客户端机器名

查看连接到db的进程，程序名，客户端机器名select * from v$session vs where vs.STATUS = 'ACTIVE'; select * from v$process vp; select vs.SID, vs.SERIAL#, vs.USERNAME, vs.STATUS, vs.SCHEMANAME, vs.OSUSER, vs.PROCESS, vs.MACHINE, vs.PORT, vs.TERMINAL, vs.PROGRAM, vs.TYPE from v$session vs where vs.STATUS = 'ACTIVE' and vs.SCHEMANAME <> 'SYS' order by vs.USERNAME desc;