Re: Things to validate / collect before Killing a session !!!!

RE: Things to validate / collect before Killing a session !!!!Hi

In Oracle8i PMON defers transaction recovery of "killed" sessions to SMON which may use fast start parallel rollback if necessary. This frees up locks held by the killed process immediately. If you kill -9, it might appear that the session is gone "faster" but not really. Oracle might be doing on demand recovery of the blocks wich makes it "appear" faster.

Alessandro Guimaraes

• Original Message ----- From: AK To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 08, 2003 3:34 PM Subject: Re: Things to validate / collect before Killing a session !!!!

  This is where smon will come into picture and clear any locks or rollback data .   Just a guess .

-ak

• Original Message ----- From: Reddy, Madhusudana To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 08, 2003 2:43 PM Subject: RE: Things to validate / collect before Killing a session !!!!

    My Question is very simple , sorry to be ambiguous with my poor English...

    We can kill a session either by " Alter System Kill Session ... " or by identifying the PID and use KILL command on OS Side .

    Sometimes to rollback the huge transaction , Oracle keeps the session in " KILLED" status , but it wont really clear the session , unlike KILL from OS ( correct me if I am wrong ) . My question is HOW Oracle is going to rollback the transaction when we use the KILL -9 <PID> as the session immediately disappears when we query V$SESSION for SID.

    And also are there any parameters in init.ora that are going to effect the Rollback ( Any Parallel Rollback ??? ).

      [Madhu, Reddy]

       -----Original Message-----
      From: Arun Annamalai [mailto:oracle_at_shakaboom.com]
      Sent: Tuesday, April 08, 2003 3:34 PM
      To: Multiple recipients of list ORACLE-L
      Subject: Re: Things to validate / collect before Killing a session !!!!


      Madhu.

      You seem to be confused between "kill -9" and "Alter system" and adding to the confusion.."rollback" and "PARALLEL"

      I suggest read the Concepts manual, epc on how client and server process work for an oracle session.

      -Arun.
      Sr. Oracle DBA
        ----- Original Message ----- 
        From: Reddy, Madhusudana 
        To: Multiple recipients of list ORACLE-L 
        Sent: Friday, April 04, 2003 2:53 PM
        Subject: RE: Things to validate / collect before Killing a session !!!!


          Thanks Kurt !!!

          All,

          what Actually Oracle will do when we kill the JOB by " kill -9" , instead of "Alter System ....".  What about the Rollback  ??
          Any PARALLEL parameters in init.ora has any effect if we kill the process by "kill -9".
          Any other inputs on " Collecting the stats before killing a session " ??

          [Madhu, Reddy] 

           -----Original Message-----
          From: Wiegand, Kurt [mailto:Kurt.Wiegand_at_CWUSA.COM]
          Sent: Friday, April 04, 2003 11:24 AM
          To: Multiple recipients of list ORACLE-L
          Subject: RE: Things to validate / collect before Killing a session !!!!


          I always check to see how much rollback they have in case I want to watch 
          it rollback and I always make sure I get the pid for the associated UNIX 
          process in case I decide I need to kill it.  Of course, I always almost 
          remember to do these two things. 

          Kurt 

          -----Original Message----- 
          From: Reddy, Madhusudana [mailto:Madhusudana.Reddy_at_bestbuy.com] 
          Sent: Friday, April 04, 2003 11:34 AM 
          To: Multiple recipients of list ORACLE-L 
          Subject: Things to validate / collect before Killing a session !!!! 



          Hi List, 
          We all need to kill the user sessions in the situations of locking or sometime on end user / application support person's request . I would like to know best practices followed before killing a session , Any of you collect some information/statistics before kill ?? 

          Please share your ideas and advice me  on this. 

          Thanks in advance,Madhu 



          -- 
          Please see the official ORACLE-L FAQ: http://www.orafaq.net 
          -- 
          Author: Reddy, Madhusudana 
            INET: Madhusudana.Reddy_at_bestbuy.com 

          Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
          San Diego, California        -- Mailing list and web hosting services 
          --------------------------------------------------------------------- 
          To REMOVE yourself from this mailing list, send an E-Mail message 
          to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
          the message BODY, include a line containing: UNSUB ORACLE-L 
          (or the name of mailing list you want to be removed from).  You may 
          also send the HELP command for other information (like subscribing). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?Q?Alessandro_Guimar=E3es?=
  INET: alessandro_at_applysolutions.com.br

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).