DEVFYI - Developer Resource - FYI

Where can one find I/O statistics per table? (for DBA

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

384. Where can one find I/O statistics per table? (for DBA

The UTLESTAT report shows I/O per tablespace but one cannot see what tables in the tablespace has the most I/O. The $ORACLE_HOME/rdbms/admin/catio.sql script creates a sample_io procedure and table to gather the required information. After executing the procedure, one can do a simple SELECT * FROM io_per_object; to extract the required information. For more details, look at the header comments in the $ORACLE_HOME/rdbms/admin/catio.sql script.

(Continued on next question...)

Other Interview Questions