| |
 |
|
Oracle Tips by Burleson |
Database Writer Tuning
Database writer tuning involves two basic areas, first, how often
writes are accomplished and how much is written in each write and
second, how many writer processes are designated to service the
database output requirements. The V$SYSSTAT view should also be used
to calculate the value for the average length of the dirty write
queue, values larger than 100 show need for more DB_BLOCK_BUFFERS or
DB_WRITERS or a need to increase the size of the
DB_BLOCK_WRITE_BATCH (which becomes an undocumented parameter
beginning with Oracle8.)
Figure 6 shows a select taken from “Oracle Performance Tuning” ,
Mark Gurry and Peter Corrigan, O’Reilly Press.
SELECT
DECODE (name, ‘summed dirty write queue length’, value)/
DECODE (name, ‘write requests’, value) “Write Request Length”
FROM v$sysstat
WHERE...
See code depot
This is an excerpt by
Mike Ault’s e-book:
Tuning
Third-party Vendor Oracle Systems
Tuning when you can't touch the code
ISBN:
0-9740716-3-3
http://www.rampant-books.com/ebook_vendor_tune.htm
|
