I am using oracle 10g (10.2.0.1) in Redhat Ent Linux 5.0 .
In my production database , One of my session which is connected thorugh 'TOAD' program is hanged on .
I kill this session several times but not removed from the session and it shows status is 'KILLED' .
Here is the output :
SQL> select username,sid,serial#,status from v$session where status='KILLED';
USERNAME SID SERIAL# STATUS
------------------------------ ---------- ---------- --------
DBPROD 1860 37381 KILLED
SQL> alter system kill session '1860,37381' ;
alter system kill session '1860,37381'
*
ERROR at line 1:
ORA-00031: session marked for kill
SQL> alter system kill session '1860,37381' immediate;
alter system kill session '1860,37381' immediate
*
ERROR at line 1:
ORA-00031: session marked for kill
Also during kill session , there is no message shows in the alert log file related with kill command .
Now please help me how can I resolve this problem without shutting down the database .