Hi Guys,


Just wanted to clarify the issue:

I know that I have to use

a) alter system to kill oracle sessions....
b) user orakill to kill NT threads..........

The issue here is to automate the orakill via a script.I am trying to do that via a query....but the query is not returning any records ...........

Now the query.....

select ......
from v$process p,v$session s
where p.addr = s.addr
where s.status='KILLED' ....................

is not getting me any records.

If I take out s.status='KIILLED' ,it does show up other sessions which were not killed.

But I have to orakill killed sessions.......................


Regards,
Copernicus.