Killing session
452030Jan 31 2008 — edited Jan 31 2008Session 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