查看连接到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;