Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Explain What is Oracle Logical IO
> I/O where you did not have to go to the disks (from Oracle's
> perspective).
>
> ie "I want read some data from a block, send out a read request - great
> it already in memory"
As an addition, even if you read only one row from a block, this might result in more than one logical IOs, such is the case with consistent read when undo blocks have to be get to build consitent image of a data block.
Tanel. Received on Sun Aug 24 2003 - 01:28:15 CDT