Hi,

I am killing oracle sessions but Oracle is not giving up the
memory.It still shows up as a killed session in v$session.

Some body suggested I use orakill and I am trying to automate the query using
select 'orakill'...................

where v$session.status='KILLED' and
v$session.paddr=v$process.addr
/

but the query is not returning any rows.

Any ideas ?

Thanks,
Copernicus.