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

From: Jose Luis Delgado <joseluis_delgado_at_yahoo.com>
Date: Wed, 09 Apr 2003 06:48:49 -0800
Message-ID: <F001.0057DDBF.20030409064849@fatcity.com>

• "Reddy, Madhusudana" <Madhusudana.Reddy_at_bestbuy.com> wrote:
  > 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.
  >
  

According to the Oracle docs...

PMON will do the job! it will rollback the transaction!

HTH   
> And also are there any parameters in init.ora that
> are going to effect the Rollback ( Any Parallel
> Rollback ??? ).
>
>
>
> [Madhu, Reddy]
>
> -----Original Message-----
> Sent: Tuesday, April 08, 2003 3:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 -----
> To: Multiple recipients of list ORACLE-L
> <mailto:ORACLE-L_at_fatcity.com>
> Sent: Friday, April 04, 2003 2:53 PM
>
>
>
> 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-----
> Sent: Friday, April 04, 2003 11:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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-----
> Sent: Friday, April 04, 2003 11:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
>

---

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: joseluis_delgado_at_yahoo.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).

Received on Wed Apr 09 2003 - 09:48:49 CDT