you are evil. :) as far as I know, mttr overrides log_checkpoint_interval if set. That's what it says in the docs I've looked at
I haven't had a chance to play around with it as yet though. --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > <evil smirk> > By all means, play around in their test database. See how good he is > when it > goes crashy-crashy... > <innocent smirk> > > -----Original Message----- > Sent: Tuesday, November 19, 2002 4:10 PM > To: Multiple recipients of list ORACLE-L > > > > ok - it so happens I am in the middle of the 9i New Features class. I > just > clarified that with the instuctor. And he repeated that if the > log_checkpotint parameters are set, as well as the MTTR, then MTTR > overides > whatever the log_checkpoint parameters are set to. > > > I did not check out the official documentation. But the class manual > says, > > > 'Internally this is translated to a setting for > Log_checkpoint_interval' > > > The instructor's name is Steve Bertuoi. Not sure how good he knows > his > stuff. > > > I guess I could play around with their test database here in the > class, and > see what really happens. > > > Gillian > > > DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > > > Gillian - But the documentation clearly says just the opposite. It > says that > if you set the LOG_CHECKPOINT_INTERVAL parameter, then that is what > is used, > rather than FAST_START_MTTR_TARGET. So I don't see how you can say > that > FAST_START_MTTR_TARGET overrides the LOG_CHECKPOINT_INTERVAL. Am I > missing > something here? > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Tuesday, November 19, 2002 12:59 PM > To: Multiple recipients of list ORACLE-L > > > > Just to add: > > > The MTTR parameter overides the Log_checkpoint_interval and the > ...timeout > parameter. Oracle sets these log_checkpoint parameters dynamically > when the > MTTR parameter is set. > > > Gillian > > > DENNIS WILLIAMS wrote: > > > Dist - > Since nobody seems to have responded,! ! I'll take a crack at it. > The Oracle9i documentation specifically says (in the Oracle9i > Database > Reference) that either FAST_START_IO_TARGET or > LOG_CHECKPOINT_INTERVAL will > override FAST_START_MTTR_TARGET. I would tend to believe them. > In the Oracle9i Performance Tuning Guide, Oracle contains a note that > you should disable or remove the FAST_START_IO_TARGET, > LOG_CHECKPOINT_INTERVAL, and LOG_CHECKPOINT_TIMEOUT parameters when > using > FAST_START_MTTR_TARGET. Setting these parameters interferes with > FAST_START_MTTR_TARGET. > I don't see where LOG_CHECKPOINTS_TO_ALERT would cause a problem, but > if > you are suspicious, you might check metalink. > As I understand it, the big advantage of FAST_START_MTTR_TARGET is > its > ease and accuracy. Your management provides a goal for how long your > Oracle > database can take to reco! ! ver in the situation where it crashes. > You > simply > convert that number to seconds and set FAST_START_MTTR_TARGET. With > the > ! ! LOG_CHECKPOINT parameters, the settings are derived more > indirectly. > Of course, there is no free lunch. Setting a shorter recovery time > may > interfere with performance. > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Monday, November 18, 2002 11:04 AM > To: Multiple recipients of list ORACLE-L > log_checkpoint_interval parameter? > > > > > > I saw a document mention if log_checkpoint_interval define on ORACLE > 9i, > the fast_start_mttr_target parameter will be ignore. My question is: > > 1. we have following on init.ora file: > > log_checkpoint_interval = 10000 > log_checkpoint_timeout = 1800 > log_checkpoints_to_alert = true > > fast_start_mttr_target=300 > > Do I need remove all the log_checkpoint* on init.ora file? > > 2. what kind of ! ! benefit that fast_start_mttr_target better than > log_checkpoint* ? > > > Thanks > > > > ______________________! ! ___________________________________________ > The new MSN 8: smart spam protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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 offic! ! ial ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat Ci! ! ty Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > > > > > _____ > > Do you Yahoo!? > Yahoo! > Web Hosting - Let the expert host your site > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services! ! > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > === message truncated === __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
