PIO

From Oracle FAQ
Jump to: navigation, search

PIO or Physical I/O refers to reading and writing from/to disk.

Monitor[edit]

To monitor the PIO of an Oracle database, execute:

SELECT name, value FROM v$sysstat
 WHERE name IN ('physical reads', 'physical writes');

Also see[edit]

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