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