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