db_block_checkpoint_batch

From: elain he <elainhe_at_hotmail.com>
Date: Tue, 13 Feb 2001 08:13:21 -0800
Message-ID: <F001.002B2777.20010213062611@fatcity.com>

Hi,
Has anyone seen database performance degradation by setting this to a high value?

We set this value to 128 from the default value 4 and noticed a lot more free buffer waits event.

All database writers (DB01-10) are waiting for Null Event. The seconds_in_wait time from v$session_wait is 129614(~1.5days), ie the same time since the database started. The parent DBWR process is waiting on rdbms ipc message and the seconds_in_wait time is 0.

Here's the configuration:
DB 7.3.4
db_writer=10
async_io disable
Solaris 2.6/Sun T3 Array
_db_block_write_batch=512
db_block_checkpoint_batch=128 (512/4)

Appreciate any help you can provide.
Thanks.

--Elain

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: elain he
  INET: elainhe_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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 Feb 13 2001 - 10:13:21 CST