Re: Explain What is Oracle Logical IO

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3F480F7F.157B_at_yahoo.com...
> Yakub wrote:
> >
> > Can someone explain what Oracle's Logical IO is?
> >
> > Thanks
>
> 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"

Hmm. I've always had (see my reply on c.d.o.m) *all* IO in mind as the answer for this. (though the definition of the various stats needs careful reading when you come to practicalities like calculating ratios :( )

I guess thats purely a definition thing though. And my definition doesn't leave any room for physical io=illogical io :(

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************