select spid, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr and sid=sessionsid
SPID OSUSER
------------------------ --------------------------
PROGRAM
---------------------------------------------------
3760 oracleplus
In windows CMD:
C:\>orakill ora92 3760
Kill of thread id 3760 in instance ora92 successfully signalled.
C:\>
ora92是你數據庫的sid.
v$process p, v$session s where p.addr=s.paddr and sid=sessionsid
SPID OSUSER
------------------------ --------------------------
PROGRAM
---------------------------------------------------
3760 oracleplus
In windows CMD:
C:\>orakill ora92 3760
Kill of thread id 3760 in instance ora92 successfully signalled.
C:\>
ora92是你數據庫的sid.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11411056/viewspace-733353/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11411056/viewspace-733353/