Geek asks and answers

How to shut down Oracle procedures that are running

I created an oracle procedure. When I run it from sqldevoloper, in some case I think it goes into an infinite loop. It continues to generate log files. How can I complete this procedure? I stopped the oracle service through services.msc. When I run it again, log files are generated. I think this procedure works. How can I stop these procedures.

+5
source share
2 answers

Define your session (hanging) from a v $ session using

select sid, serial#, status from v$session where USERNAME='NAME';

And then kill him using

ALTER SYSTEM KILL SESSION 'SID,#SERIAL';
+13
source 
ALTER SYSTEM KILL SESSION

But you need to get a session id and have rights.

0
source

More articles:


All Articles