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

Add to this list : If the Rollback involves Remote Updates , that is going to slow down the release
of the process further.

HTH GovindanK

Madhusudana.Reddy_at_bestbuy.com wrote:

>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
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: mail2gkatteri_at_netscape.net

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).