Hi.

when I perform the following sql, it shows me lot of 'waits';

here are the basic parameters and we are using unix on ibm (AIX)
1G Memory and 4 CPU

db_block_size = 8192
db_block_buffers = 12000
shared_pool_size = 46080000
db_writer_processes = 2
db_block_lru_latches = 2

Would anyone agree to use dbwr_io_slaves instead? would the following helps?

dbwr_io_slaves = 10
db_writer_processes = 1


Thx.

============================================
OPS$MATTHEWC>
1 select event, total_waits, average_wait from v$system_event
2 where event in ('buffer busy wait', 'db file parallel write', 'write complete waits')
OPS$MATTHEWC> /

EVENT TOTAL_WAITS AVERAGE_WAIT
------------------------------ ----------- ------------
db file parallel write 25324 250.058877

1 row selected.

OPS$MATTHEWC>
============================================

db_block_size = 8192
db_block_buffers = 12000
shared_pool_size = 46080000
db_writer_processes = 2
db_block_lru_latches = 2