v$filestat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: v$filestat

  1. #1
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I have just freaked out upon seeing this. File# 12 belongs to an index tablespace. Why are the values so high?? Any ideas?? Thanx in advance.


    FILE# READTIM MAXIORTM
    --------- --------- ---------
    1 8783, 40
    2 0, 41
    3 100, 51
    4 1312, 5284
    5 493, 68
    6 0, 75
    7 0, 77
    8 22290, 81
    9 6137, 86
    10 1773, 88
    11 31791, 95
    12 137849273, 15113597
    13 36994, 111
    14 39929 111
    15 17719 111
    16 24546 114

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    probably the indexes of tables are larger than the tables themself so I/O in index file is larger


  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759

    Angry

    Matter of fact all indexes in this ts are smaller than the table they are associated with.

  4. #4
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    You could look inside the file to see what objects reside there and see if you have a heavily used/updated index on there.

    I do know that there are some bugs that are associated with this view. Particularly if you have set DBWR_IO_SLAVES > 0 is this the case? You might want to file a tar and see if you are hitting one of those bugs. I think there are three or four of them.

    Joe
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    As a matter of fact, I have dbwr_io_slaves=1 in the init.ora. Thanx for the input, I'll check up on the bugs (if any).

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