IO information on tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: IO information on tables

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Question

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

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    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

  3. #3
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    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.


  4. #4
    Join Date
    Sep 2000
    Posts
    384
    Good Information..
    Radhakrishnan.M

  5. #5
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Wink

    Thanks for the info.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width