RE: log file sequential read - arguments P3

Hi Alex

In "Oracle Wait Interface: A Practical Guide to Performance Diagnostics = & Tuning" is written:

P1: relative sequence number of the redo log file within the redo log = group
P2: block number to start reading from
P3: number of OS blocks to read starting from P2 value

Personally I can neither confirm not deny this information. Anyway till = now I found the information contained in this very good book reliable...

Chris

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org =

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alexandre
>Gorbatchev
>Sent: 01 December 2004 14:52
>To: Oracle-L_at_freelists.org
>Subject: log file sequential read - arguments P3
>
>Hi list.
>Does anybody know whether P2/P3 arguments for "log file sequential =
read" wait event are in database
>blocks or in log blocks?
>The manual is not clear but it seems to mean database block size. =
However,
>I believe that it gotta be log block size. I couldn't find anything =
useful
>on Metalink either.
>
>Thanks,
>Alex
>
>--
>http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l