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