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

Avoid deletes, updates, inserts - replace with create table/index nologging, insert+append where you can.

Then the recovery/rollback problem dissappears.

>>> vkhanna_at_quark.co.in 07/23/02 09:28p.m. >>>
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: Binley Lim
  INET: Binley.Lim_at_ird.govt.nz

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