Re: Log file sequential read ??

Yes, we are in archivelog mode.

The archive logs are on the same raid-5 set as everything else. Not my choice, but there we are.

On Wed, 20 Nov 2002 15:01:08 -0000, "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote:

>One presumes you are running in Archive log mode.
>
>
>are your log disks slower than the others ?
>
>
>"Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message
>news:3dda63b9.57518006_at_ausnews.austin.ibm.com...
>> Platform: Oracle 8.1.7.4 EE on Win2K
>>
>> A statspack report shows most of our wait event time (39.5 %) for 'log
>file
>> sequential read'. A search of MetaLink turned up lots of hits for Rdb.
>The few
>> other hits didn't really address this event, just had it mentioned in a
>list of
>> events. Pretty much the same for a search of this ng's archives. OraPerf
>> simply says 'The logfile header block was read. This could happen for
>example
>> when a new log file is added or when a logfile is dumped.'
>>
>> So, with this event fingered as my 'heavy hitter', what course of action
>would
>> you recommend?
>>
>> Anyone want to see the whole statspack report, for comment?
>> --
>> Ed Stevens
>> (Opinions expressed do not necessarily represent those of my employer.)
>
>

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)