RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-20 Thread M Rafiq
Dennis, Don't get frustrated with such remarks. You are one of the most active contributor/member of this list and atleast I like your signature 40%OCP. Yes, I agree with you that OCP is not the final word for expertise. It definatley force you to read most oracle material to get it certified b

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-20 Thread DENNIS WILLIAMS
He he. There are 5 OCP modules. I've passed 2, hence 40%. I just thought I should warn everyone that I'm not the expert that others on the list are. :-) And no, I don't believe the OCP is the final word on Oracle expertise by any means. I should probably discontinue using that signature to avoid an

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-20 Thread Hately, Mike (NESL-IT)
In the docs I've just checked for 9.2 Oracle recommends that log_checkpoint_timeout, log_checkpoint_interval and fast_start_io_target are all set to 0 if you're using fast_start_mtr_target because (as the tuning manual says) "..setting these parameters to active values interferes with FAST_START_MT

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-20 Thread Rachel Carmichael
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: > > By all means, play around in their test database. See

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-20 Thread Donahue, Adam
Dennis Williams DBA, 40%OCP ^^ How does one get to be a 40% OCP? Is that like being a 40% expert? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatci

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-20 Thread DENNIS WILLIAMS
Gillian - I love it! Dueling Instructors! Since you are still in class, why don't you show him the manual and ask for clarification. Please check the class notes on this. My copy is at home. Thanks. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-20 Thread Hately, Mike (NESL-IT)
Heh, naw it was an early morning pre-coffee reply. So probably nothing to write home about =) Mike -Original Message- Sorry Mike. I was going from memory. I'm sure your reply was better than mine, not hard to do. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Plea

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-19 Thread Fink, Dan
By all means, play around in their test database. See how good he is when it goes crashy-crashy... -Original Message-From: Gillian [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 19, 2002 4:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: [Q] ORACLE 9i

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-19 Thread Gillian
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 d

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-19 Thread DENNIS WILLIAMS
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 missin

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-19 Thread Gillian
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 <[EMAIL PROTECTED]> wrote: Dist -Since nobody seems to have responded, I'll take a crac

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-19 Thread DENNIS WILLIAMS
Sorry Mike. I was going from memory. I'm sure your reply was better than mine, not hard to do. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 19, 2002 9:54 AM To: Multiple recipients of list ORACLE-L log_checkpoint_inte "Dist -

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-19 Thread Hately, Mike (NESL-IT)
"Dist - Since nobody seems to have responded" I take offence at that =) Obviously not everyone got my reply. Or I'm on you spam list Dennis. Cheers, Mike -Original Message- Sent: 19 November 2002 13:59 To: Multiple recipients of list ORACLE-L log_checkpoint_inte Dist - Since nob

RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte

2002-11-19 Thread DENNIS WILLIAMS
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 Ora