提高DBWR进程的吞吐量

Improve DBWR Throughput

To improve DBWR’s throughput, consider the following:

  • Disk capabilities and setup (stripe size, speed, controllers etc…)
  • Using raw devices instead of File System files — depending on their efficiency on your system.
  • Spreading database file across drives and controllers
  • Using Async IO if supported
  • If asynch IO is not possible, using multiple database writers. This is done with the DB_WRITERS database parameter in Oracle7, and the DBWR_IO_SLAVES database parameter in Oracle8 and 9.
  • Using multiple DB Writer gatherer processes in Oracle8 using the DB_WRITER_PROCESSES parameter.
  • Using the “Multiple buffer pools” feature in Oracle8 and Higher. See Note:135223.1 on the Oracle Metalink website.

 

Achieving the optimal setup for DBWR is highly dependent on the characteristics of your platform. The maximum I/O size the platform supports and the ability to support Asynchronous I/O are examples of these characteristics.

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号