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: Vikas Khanna <vkhanna_at_quark.co.in>
Date: Tue, 23 Jul 2002 01:28:22 -0800
Message-ID: <F001.0049F1FF.20020723012822@fatcity.com>


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

-----Original Message-----

Sent: Tuesday, July 23, 2002 1:48 PM
To: Multiple recipients of list ORACLE-L

List,
...was doing a looonnnng update, was taking forever, i rebooted the PC, as expected, the *open* of the instance is taking a very long time.. and i cannot wait...
is there a way to open the DB *without* letting oracle perform the thread recovery ??
i just to open the DB.... data lose is acceptable..

TIA
-rahul

--

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vikas Khanna
  INET: vkhanna_at_quark.co.in
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:28:22 CDT

Original text of this message

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