| very high redo space wait ratios on 10g [message #259214] |
Tue, 14 August 2007 12:15  |
sumang24
Messages: 10
Registered: July 2005
|
Junior Member |
|
|
I upgraded the db from 9i to 10g recently. These are the stats:
The redo space wait ratio on 9i : 0.6708
The redo space wait ratio on 10g : 1112.21
9i:
Size of redo log file = 10 MB
4 groups with 2 members each
size of redo buffer: 14.7 MB
Total System Global Area 1249391632 bytes
Fixed Size 455696 bytes
Variable Size 721420288 bytes
Database Buffers 512000000 bytes
Redo Buffers 15515648 bytes
10g:
Size of redo log file = 10 MB
4 groups with 2 members each
size of redo buffer: 30 MB
sho sga
Total System Global Area 4378853376 bytes
Fixed Size 2035792 bytes
Variable Size 822087600 bytes
Database Buffers 3523215360 bytes
Redo Buffers 31514624 bytes
Do you think that the increased size of redo buffer ( almost double) on 10g is a contributing factor to high redo space
wait ratios. I have set the log_buffer to 14.6 MB in the spfile but because of
the granule size it shows at 30 MB on the v$sga view. I don't have any control
on the buffer size.
Thank You
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
