-
Any ideas on how to get phys read/phys write information on all tables in a tablespace, ordered by table name?
-
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 .
Radhakrishnan.M
-
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.
-
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|