How to kill a oracle session in windows:
First select the spid:
SELECT p.SPID,s.Program,CLIENT_INFO,s.LOGON_TIME FROM V$SESSION s, V$PROCESS p WHERE s.PADDR=p.ADDR AND s.Program like 'RMAN%' ;
On Windows, there is a command-line utility called ORAKILL which lets you kill a specific thread in this situation. From a command prompt, run the following command:
orakill sid thread_id
that is
orakill orcl thread_id=spid from above command
First select the spid:
SELECT p.SPID,s.Program,CLIENT_INFO,s.LOGON_TIME FROM V$SESSION s, V$PROCESS p WHERE s.PADDR=p.ADDR AND s.Program like 'RMAN%' ;
On Windows, there is a command-line utility called ORAKILL which lets you kill a specific thread in this situation. From a command prompt, run the following command:
orakill sid thread_id
that is
orakill orcl thread_id=spid from above command
No comments:
Post a Comment