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).


To monitor the LIO of an Oracle database, execute:

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

Also see[edit]

  • 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 #