-
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
matthewc
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|