Home » RDBMS Server » Server Administration » error in kill the session
icon9.gif  error in kill the session [message #193456] Sun, 17 September 2006 04:02 Go to next message
sonaliakolkar
Messages: 3
Registered: August 2006
Junior Member
Dear All

I hv a query regarding Procedures. I have a procedure compiled and
is in valid status. We use it to collect data from diff. tables and insert it in one table.
When I execute this procedure, it works fine. But when for some
misc. reasons I killed the session where this procedure was running.
Even if I have killed the session the procedure was still running in the background and
is still inserting records in destination table. I had to restart the database to come out of the procedure.
Can any of u gurus guide me for this problem ? How can come out of this procedure except restarting the database.


Please can any body help on this front.

sonali
Re: error in kill the session [message #193474 is a reply to message #193456] Sun, 17 September 2006 12:54 Go to previous messageGo to next message
aorehek
Messages: 52
Registered: August 2006
Member
Use orakill.It is utility under oracle\bin directory ( on the server side ).
Re: error in kill the session [message #193538 is a reply to message #193474] Mon, 18 September 2006 02:52 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
when i kill the session and i faced the error
session could not be killed due intruptable network error but marked for kil
do u have any idea about this error and will u please guide me to solve this problem
can u please tell me the comlete syntax of utility orakill
Re: error in kill the session [message #193803 is a reply to message #193538] Tue, 19 September 2006 08:36 Go to previous message
pareshr
Messages: 18
Registered: August 2006
Location: Ahmedabad
Junior Member

Hi,
1)
---See the sessions

SELECT s.sid,
s.serial#,
s.osuser,
s.program
FROM v$session s;

SID SERIAL# OSUSER PROGRAM
---------- ---------- ------------------------------ ---------------
1 1 SYSTEM ORACLE.EXE
2 1 SYSTEM ORACLE.EXE
3 1 SYSTEM ORACLE.EXE
4 1 SYSTEM ORACLE.EXE
5 1 SYSTEM ORACLE.EXE
6 1 SYSTEM ORACLE.EXE
20 60 SYSTEM DBSNMP.EXE
43 11215 USER1 SQLPLUSW.EXE
33 5337 USER2 SQLPLUSW.EXE


2)SQL> ALTER SYSTEM KILL SESSION 'sid,serial#';
3) SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;
4)C:> orakill ORACLE_SID spid

Paresh Rupareliya...
Previous Topic: oracle 9i Heterogeneous Services problem pls help
Next Topic: hi
Goto Forum:
  


Current Time: Wed Dec 04 19:25:40 CST 2024