Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Log writer hammering disk io + report.txt

Re: Log writer hammering disk io + report.txt

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Sun, 17 May 1998 13:38:51 +0200
Message-ID: <6jmios$5v0$1@news.worldonline.nl>


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



Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US