Killing sessions not releasing memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Killing sessions not releasing memory

  1. #1
    Join Date
    Aug 2002
    Posts
    15
    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.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    well v$session shows user process, look v$process for server process, if it's not there then most probably the resources are freed

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    May 2001
    Posts
    25
    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

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    I'm still dealing with this...

    Reddy,Sam

  7. #7
    Join Date
    Aug 2002
    Posts
    15

    Clarifying my question..........

    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.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width