IO information on tables

[rgaskell]

Any ideas on how to get phys read/phys write information on all tables in a tablespace, ordered by table name?

[omegamark]

As far as i know physical i/o information can be known onlu by tablespace wise only(Datafiles) and not by tables .

But if you want to know the physical writes like inserts,update on a table well you can do that....

but here you can't tell the phyical reads by tables....like select .

[Mara]

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.

[omegamark]

Good Information..

[rgaskell]

Thanks for the info.....