v$filestat

[Halo]

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

[pando]

probably the indexes of tables are larger than the tables themself so I/O in index file is larger

[Halo]

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

[wjramsey]

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

[Halo]

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).