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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: fast_start_io_target -- which buffer?

RE: fast_start_io_target -- which buffer?

From: Ganesh Raja <gans_r_at_rediffmail.com>
Date: Tue, 08 Apr 2003 07:28:53 -0800
Message-ID: <F001.0057CCA9.20030408072853@fatcity.com>


U Can Say Never ...

There are Dirty Buffers in the disk too...

Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
-----Original Message-----
Wagner
Sent: Tuesday, April 08, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L

immediately after a checkpoint?
(And thanks to all who replied!!)
-----Original Message-----
Sent: Monday, April 07, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L

At startup????

At 01:53 PM 4/7/03 -0800, you wrote:
>Nick - Data buffers. Specifically dirty data buffers (modified). The
Oracle
>secret to high transaction throughput is that it never writes anything
to
>disk until to optimum time. An Oracle trivia question (as in OCP
trivia) is
>"when does the Oracle data buffer contain no dirty buffers?".
>
>
>
>Dennis Williams
>DBA, 40%OCP, 100% DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>-----Original Message-----
>Sent: Monday, April 07, 2003 4:04 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>according to the Oracle documentation for FAST_START_IO_TARGET...
>
>----------------------------------------
>Set this parameter to n, where n is an integer limiting to n the number
of
>"buffers" that Oracle processes during crash or instance recovery.
Because
>the number of I/Os to be processed during recovery correlates closely
to the
>duration of recovery, the FAST_START_IO_TARGET parameter gives you the
most
>precise control over the duration of recovery.
>BM_434315
>FAST_START_IO_TARGET advances the checkpoint, because DBWn uses the
value of
>FAST_START_IO_TARGET to determine how much writing to do. Assuming that

>users are making many updates to the database, a low value for this
>parameter forces DBWn to write changed "buffers" to disk. As the
changed
>"buffers" are written to disk, the checkpoint advances.
>BM_434316
>The smaller the value of FAST_START_IO_TARGET, the better the recovery
>performance, because fewer blocks require recovery. If you use smaller
>values for this parameter, however, then you impose higher overhead
during
>normal processing, because DBWn must write more buffers to disk more
>frequently.
>-----------------------------------------
>
>My question... which "buffers" are they referring to here? The log
buffer?
>
>
>Thanks!!
>
>Nick
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>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
>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).



Scott Stefick
Systems / Oracle Certified DBA
Wm. Rainey Harper College
847.925.6130
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Scott Stefick 
  INET: sstefick_at_harpercollege.edu 
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 official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ganesh Raja
  INET: gans_r_at_rediffmail.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 Tue Apr 08 2003 - 10:28:53 CDT

Original text of this message

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