LIO
From Oracle FAQ
LIO or Logical I/O refers to reading and writing from/to memory (for example, from/to the SGA Buffer Cache).
Monitor[edit]
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 | # |