Where can one find I/O statistics per table?
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.
Related Questions
- However, table clustering has demonstrated a significant improvement in the I/O scan performance.27. Where can I find additional information about the cluster table attribute?
- Why does the Monthly Statistics table for the wind shear parameter show different numbers than the Wind Shear Analysis window?
- How I can determine whether table, index or column statistics are missing?
