Re: Explain what is Oracle Logical IO

"Billy Verreynne" <dev_at_null.com> wrote in message news:3f4717ad$0$64727_at_hades.is.co.za...
> Yakub wrote:
>
> > Please explain what Oracle Logical IO is
>
>
> Logical I/O != Physical I/O

But Physical I/O = Logical I/O ta da.

Ok what I mean is logical I/O consists of *every* io request (usually for a database block read or update, but also logs etc) that Oracle makes. Physical I/O are those io requests that result in a physical disk access.

-- 
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
******************************************