 error in kill the session [message #193456] |
Sun, 17 September 2006 04:02  |
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 #193538 is a reply to message #193474] |
Mon, 18 September 2006 02:52  |
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 |
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
