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!

Killing session

452030Jan 31 2008 — edited Jan 31 2008
Session were killed in the database, but they are still in v$session with the status as "killed". These processes do not have any entry in v$transaction
I issued the following query :
select * from v$transaction, v$session where addr=taddr
and sid in (select sid from v$session where status='KILLED')
and no rows were returned
...which means no rollback is going on for the processes.
I queried in v$session_wait for the sids and they were waiting for "SQL*Net message from client"
Please suggest me It is suitable if i killed this session using orakill utility.
I have Oracle 10g release 2.
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2008
Added on Jan 31 2008
6 comments
542 views