Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Logical IO, Pure Logical IO, Physical IO

sk12345678Nov 25 2011 — edited Nov 28 2011
Can some one clarify the below
1) difference between Logical IO and Pure Logical IO. When do these occur?
2) Why high logical IO is not good for performance.

I am confused by reading about these three IOs and the order in which these get invoked. Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2011
Added on Nov 25 2011
1 comment
584 views