RE: log file sequential read - arguments P3
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <agorbatchev@xxxxxxxxxxx>
- Date: Wed, 1 Dec 2004 15:15:09 +0100
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alexandre
>Gorbatchev
>Sent: 01 December 2004 14:52
>To: Oracle-L@xxxxxxxxxxxxx
>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
>
>--
>//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
