From Oracle FAQ
Jump to: navigation, search

LIO or Logical I/O refers to reading and writing from/to memory (for example, from/to the SGA Buffer Cache).

[edit] Monitor

To monitor the LIO of an Oracle database, execute:

SELECT name, value FROM v$sysstat
 WHERE name IN ('db block gets', 'consistent gets');

[edit] Also see

  • PIO - physical I/O
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #