Re: redo logs tuning?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 05 Sep 2000 09:18:58 GMT
Message-ID: <39b4b9fb.104161686@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 Tue Sep 05 2000 - 04:18:58 CDT