| redo log contetnion [message #62450] |
Thu, 22 July 2004 07:40  |
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
|
|
|
|
|
|
| Re: redo log contetnion [message #62479 is a reply to message #62465] |
Fri, 23 July 2004 06:54  |
ramesh
Messages: 123
Registered: August 2000
|
Senior Member |
|
|
the database will be
offline only once in a week
after taht time the contention is very little
when it reaches weekends it will be higher around
100 to 130.is it a really a problem
|
|
|
|
| Re: redo log contetnion [message #62493 is a reply to message #62479] |
Fri, 23 July 2004 23:04 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
I don't think this is an issue at all. Some statistics are cumulative; a restart will reset it to 0. However, if you tell us what you are looking at, we would be able to confirm!
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
