Killing sessions not releasing memory

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.

PMON may take some time to freeup resources after you killed the process.

If you are on unix, you can do a kill -9 on the process, Br careful while using this command.

HTH
Sanjay

well v$session shows user process, look v$process for server process, if it's not there then most probably the resources are freed

Try this:

http://www.oracle-base.com/Articles/...leSessions.asp

Cheers

Dear friend..

ORAKILL is a DOS Prompt command, it you want to kill a session then you can kill the session by two ways.

1. Using the alter session kill command through the Oracle SQL PLus

2. through the ORAKILL dos command.

Whenever you are killing any session, it takes sometime to free from memory...


Naresh Kakrani
Reliance Telecom Ltd

http://www.dbasupport.com/forums/sho...threadid=25863

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.