Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: redo logs tuning?
Steve,
In your opinion will striping the redo log files across two or more drives help improve performance?
Cheers,
Craig.
"Steve Adams" <steve.adams_at_ixora.com.au> wrote in message
news:39b4b9fb.104161686_at_nsw.nnrp.telstra.net...
> Hi All,
>
> No, the units for the log_checkpoint_interval are log blocks. The log
block size
> is platform specific. It is often 512 bytes, but by no means always. The
"Why
> raw log files?" tip on the Ixora web site contains a table of the log
block
> sizes for the most popular platforms.
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
> @
> @ Going to OpenWorld?
> @ Catch the Ixora performance tuning seminar too!
> @ See http://www.ixora.com.au/seminars/ for details.
>
>
> On Mon, 4 Sep 2000 19:05:01 +0200, "Sybrand Bakker"
<postbus_at_sybrandb.demon.nl>
> wrote:
>
> >
> >"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
message
> >news:8ovunp$2b7$1_at_soap.pipex.net...
> >> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> >> news:968007698.22997.0.pluto.d4ee154e_at_news.demon.nl...
> >>
> >> > Also, don't forget to check log_checkpoint_interval in init<sid>.ora.
In
the
> >> > 5M situation it should be 10000.
> >>
> >> Presumably for a 2k Block Size? If not how did you arrive at this
figure?
> >> --
> >> Niall Litchfield
> >> Oracle DBA
> >> Audit Commission UK
> >>
> >>
> >AFAIK this is in 512-byte units.
> >
> >Regards,
> >
> >Sybrand Bakker, Oracle DBA
> >
> >
> >
>
Received on Wed Sep 06 2000 - 18:08:12 CDT
![]() |
![]() |