it can also help you shoot yourself in the foot by forcing checkpoints too often/not often enough....

-----Original Message-----
From: Krishna Kandula
[mailto:oracledba-ezmlmshield-x72779793.[Email address protected]
Sent: Wednesday, December 29, 2004 5:43 PM
To: LazyDBA Discussion
Subject: RE: FAST_START_MTTR_TARGET


This parameter more or less controls the checkpoint process based on the
size of your redo logs.

Krishna Kandula
Sr. Data Analyst
Oracle Certified Professional DBA
Tiermed Systems LLc.
952 345 2050(O)
317 840 1926(C)


-----Original Message-----
From: MCCCLAYTON
[mailto:oracledba-ezmlmshield-x23069335.[Email address protected]
Sent: Wednesday, December 29, 2004 10:03 AM
To: LazyDBA Discussion
Subject: FAST_START_MTTR_TARGET


I've been looking Metalink on this parameter for a 9i database, and I have a
question for the Oracle DBA Continuim. What's the advantage of setting this
parameter for 'X' amount of seconds to elapse before performing a crash
recovery? I would think that the faster the recovery the better, Right?
Therefore, leaving the parameter set to 0.


Mark


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page