Killing sessions not releasing memory

[Copernicus]

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.

[SANJAY_G]

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

[pando]

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

[TimHall]

Try this:

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

Cheers

[ctcyl]

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

[sreddy]

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

[Copernicus]

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.