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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 24 Aug 2003 09:56:11 +0200
Message-ID: <vkgrsueitk672d@corp.supernews.com>

"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message news:3f485b00$1_1_at_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.
>
>

Couldn't you just better post all the relevant passages from the FM?

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sun Aug 24 2003 - 02:56:11 CDT

Original text of this message

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