| database stats analysis(urgent) [message #55894] |
Fri, 21 February 2003 23:39  |
kareka
Messages: 18
Registered: January 2003
|
Junior Member |
|
|
hi! all
the productions database running in my firm presents the following stats ...the checkpoint parameter is set to timeout (1800) the size of logfiles is 100mb...
please reply if the values presented are cause of concern...
thanks
async disk IO 834 0 3.34
buffer busy waits 20 0 0
control file heartbeat 1 1 4.1
control file parallel write 54220 0 76.7
control file sequential read 16896 0 123.02
db file parallel read 2 0 0.05
db file parallel write 9796 9796 8.35
db file scattered read 230834 0 754.48
db file sequential read 23200 0 119.69
db file single write 2 0 0
direct path read 679 0 2.38
direct path write 36 0 0.04
dispatcher timer 22950358 15051804 770829.92
enqueue 52 41 143.17
instance state change 2 0 0.31
latch free 93842 93725 8.98
LGWR wait for redo copy 10 0 0
listen endpoint status 4 0 0.08
log file parallel write 38097 38038 17.85
log file sequential read 4 0 0.01
log file single write 4 0 0
log file sync 32656 0 20.18
pmon timer 63249 62517 193800.08
rdbms ipc message 234959 200676 706582.44
rdbms ipc reply 72 0 1.35
refresh controlfile command 1 0 0.04
reliable message 2 1 1.89
single-task message 2 0 0.08
smon timer 620 488 187047.43
sort segment request 2 2 2.06
SQL*Net break/reset to client 1479 0 150.67
SQL*Net message from client 7345603 4 70128.4
SQL*Net message to client 7346246 0 38.22
SQL*Net more data from client 118 0 24.87
SQL*Net more data to client 666658 5 121.92
virtual circuit status 7258313 3264 283755.5
|
|
|
|
| Re: database stats analysis(urgent) [message #55902 is a reply to message #55894] |
Sat, 22 February 2003 23:42  |
Kishor Bhalwankar
Messages: 33
Registered: February 2003
|
Member |
|
|
Please check async i/o is available on your OS or not? If it is available than please check whether it has been configure or not?
If you have configure async i/o than no need to use the multiple dbwr processes.
If you haven't configure async I/O than please set following parameter into init.ora file:
DB_BLOCK_LRU_LATCHES=4
Tune LGWR to get good throughput to disk . eg: Do not put redo logs on RAID 5.
See if any activity can safely be done with NOLOGGING / UNRECOVERABLE options.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
