Disk Reads:
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Disk Reads:

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    Recently I created 2 partitioned tables and now the disk reads of these partitioned tables are going as high as
    3296823 and 1432681.

    I created the partitioned tables, created the indexes on them and then imported the data into these tables.
    Does it mean that I have to rebuild the index. and doing so will my disk reads comedown.

    Badrinath

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Disk reads mainly depends upon the query that requests the data from the table. It is advisable to create indexes on a table after importing the data, not before.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Increase the db_file_multiblock_read_count to 16 and see how it performs.


    SQLPLUS SYS/password@service_name
    alter system set db_file_multiblock_read_count=16;

    exit


    I hope that this would help to an extent.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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