Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to force the DB to SKIP tx recovery ?

RE: how to force the DB to SKIP tx recovery ?

From: Rahul <rahul_at_ratelindo.co.id>
Date: Tue, 23 Jul 2002 01:43:28 -0800
Message-ID: <F001.0049F24D.20020723014328@fatcity.com>


Vikas, even if the parameters were set for the checkpoint to happen often, all the
transactions *not* commited would still be rolled back !! for example, when i shut down the PC
in the middle of doing an update of 1/2 a million rows !!! (how would these parameters help?)

> ----------
> From: Vikas Khanna[SMTP:vkhanna_at_quark.co.in]
>
> No, Instance recovery has to take place internally, SMON has to recover
> the
> committed transactions which were left hanging in the cache to datafiles
> so
> that the files become synchronized.
>
> After that the db gets opened and roll backwards takes its own time. It
> depends SMON does this job in the background and any other Server process
> if
> needs that block can rollback the uncommitted transaction and proceed with
> the block.
>
> If you wish to recover the instance recovery very fast then set the
> LOG_CHECKPOINT_INTERVAL,LOG_CHECKPOINT_TIMEOUT,FAST_START_IO_TARGET
> parameters to force the checkpoints quite often, this would open the
> instance under crash quite fast as it has to perform less work. But more
> the
> checkpoints initiated more the performance degradations as B'ground
> processes would be under tremendous work.
>
> Hope it clarifies.
> Vikas Khanna
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Jul 23 2002 - 04:43:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US