Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

session is not killed properly

shipon_97Jan 2 2014 — edited Jan 2 2014

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 .

This post has been answered by Hemant K Chitale on Jan 2 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2014
Added on Jan 2 2014
2 comments
409 views