| redo log contention [message #62400] |
Tue, 20 July 2004 05:36 |
ramesh
Messages: 123
Registered: August 2000
|
Senior Member |
|
|
hi
one of our database seems
redolog contention is coming higher when days are going
when the database restarts the contention seems very less.we shutdown the database each week once.but if monday contention seems 10 then thuesday its comes around30 like that if saturday it comes around 150 or how to find a solution
for it i added the parameter value log_buffer to max after increasing it giving eror illegal parmeter error
how to reduce the redolog contention wihtout changing the parmeter value.when restarting db its ok bit confused about it
with regards
ramesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
