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" <Dan.Fink_at_mdx.com> 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 <DWILLIAMS_at_LIFETOUCH.COM> 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.
> dwilliams_at_lifetouch.com
>
> -----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.
> dwilliams_at_lifetouch.com
>
>
> -----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: mccdba_at_hotmail.com
>
> 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: 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).
> --
> Please see the offic! ! ial ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: 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).
>
>
>
>
> _____
>
> 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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: wisernet100_at_yahoo.com
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: 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).
Received on Wed Nov 20 2002 - 09:43:56 CST
