Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow 'alter tablespace begin backup'

Re: Slow 'alter tablespace begin backup'

From: srivenu <srivenu_at_hotmail.com>
Date: 28 Dec 2003 04:14:08 -0800
Message-ID: <1a68177.0312280414.26c4012f@posting.google.com>


A log switch only initiates a slow checkpoint. The checkpoint that is initiated should be completed by the time the log file is overwritten. As Jonathan has said, you can turn on incremental checkpointing by setting LOG_CHECKPOINT_INTERVAL or LOG_CHECKPOINT_TIMEOUT or fast_start_mttr_target in 9i.
regards
Srivenu Received on Sun Dec 28 2003 - 06:14:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US