Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Explain What is Oracle Logical IO

Re: Explain What is Oracle Logical IO

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sun, 24 Aug 2003 09:28:15 +0300
Message-ID: <3f485b00$1_1@news.estpak.ee>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US