Where Can One Find I/o Statistics Per Table?

1.	Where Can One Find I/o Statistics Per Table?
Answer» 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. 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.

Answer»

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.

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.

Where Can One Find I/o Statistics Per Table?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment