| help [message #2312] |
Thu, 04 July 2002 21:50  |
keane
Messages: 23
Registered: June 2002
|
Junior Member |
|
|
Hi, I executed a procedure containing an infinite loop accidently. The SQL_PLUS screen hanged. I think the procedure is still running on database. How should I stop it? Thanks a lot.
Regards,
keane
|
|
|
|
| Re: help [message #2313 is a reply to message #2312] |
Thu, 04 July 2002 22:00  |
alapps
Messages: 11
Registered: June 2002
|
Junior Member |
|
|
Hi, I executed a procedure containing an infinite loop accidently. The SQL_PLUS screen hanged. I think the procedure is still running on database. How should I stop it? Thanks a lot.
***
Login as a different DBA privileged user
use v$session to find the sid & serial# of the looping session via the other login username.
ALTER SYSTEM KILL SESSION 'sid,serial#';
This will terminate the looping session
good luck...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
