If data
>>> [EMAIL PROTECTED] 07/23/02 10:23p.m. >>> Rahul, Instance recovery requires Rollforward and Rollbackwards. If the transaction is not committed it has to be rollbacked once the instance gets started. Let us assume that there are no committed transactions which were left in the buffer cache to be flushed back on to datafiles. This means I am left with Uncommitted txns to get them rollbackwards. This is done by SMON in the background or Server process which needs those blocks but the Instance and the db are opened and ready for use. The db is opened ie. what u wanted and that's the way Oracle does work. -----Original Message----- Sent: Tuesday, July 23, 2002 2:10 PM To: '[EMAIL PROTECTED]' Cc: 'Oracle List I' 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:[EMAIL PROTECTED]] > > 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: Vikas Khanna INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Binley Lim INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
