Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Log writer hammering disk io + report.txt
Hello James,
Increasing the log buffer parameter will help.
Also, using more and larger redolog files helps (5 x 5M for a medium
sized DB)
Good luck, Roelof
James Gardner heeft geschreven in bericht
<01bd7f58$7e2426f0$eaad100a_at_wstn00172>...
>Hi, I suspect this question doesn't have a simple answer but here goes ...
>
>Although I realise that the redo logs and the log writer are prime resource
>bottlenecks. I am experiencing very high IO rates during key batch
>processes, and have narrow the culprits down to the above. What would be
>the effect of increasing the log buffer parameter.
>
>Also does anybody know where I can get more explanitory info on report.txt
>as I am struggling to derive any useful info from it.
>Jim
Received on Sun May 17 1998 - 06:38:51 CDT