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

Dennis,

PMON Should clear the failed processes, and It rolls back the transaction , How can we see this rollback as the SID disappears ?? May be Oracle might spawn ( is this the correct word to use , since PARENT is gone fishing )some other session / session(s). How to identify them ?? Or is there any way to improve , I mean to decrease the rollback time by using any init.ora parameter ( PARALLEL ) ??. Do we have control ??

Correct me if I am wrong ?

Madhu Reddy

-----Original Message-----
Sent: Tuesday, April 08, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L

Madhu

   A reasonable question indeed. The PMON process wakes up periodically and looks for failed processes. When it finds one, it rolls back the current transaction, releases all currently held locks, and frees any other resources that process currently has reserved.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, April 08, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L

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-----
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 <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L 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-----
<mailto:Madhusudana.Reddy_at_bestbuy.com> ]
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


<http://www.orafaq.net>  

-- 
Author: Reddy, Madhusudana 
  INET: Madhusudana.Reddy_at_bestbuy.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com


<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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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: 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).