db file sequential reads

All, Oracle 8.0.5.0.0 Tru64 4.0f We are having a performance issue with one of our applications and it looks like it is pointing to the db file sequential reads event. I have been doing some digging around and a recommendation in a book I have has suggested a possible way to alleviate

Re: db file sequential reads

is that the I/O is too slow ? Anjo Kolk http://www.oraperf.com Robertson Lee - lerobe wrote: All, Oracle 8.0.5.0.0 Tru64 4.0f We are having a performance issue with one of our applications and it looks like it is pointing to the db file sequential reads event. I have been doing some digging around

RE: db file sequential reads

to the db file sequential reads event. I have been doing some digging around and a recommendation in a book I have has suggested a possible way to alleviate this is to use the INDEX_FFS hint in the query. Anyone used this before ??. or indeed any other recommendations where I should be looking. Regards

RE: db file sequential reads

a performance issue with one of our applications and it looks like it is pointing to the db file sequential reads event. I have been doing some digging around and a recommendation in a book I have has suggested a possible way to alleviate this is to use the INDEX_FFS hint in the query. Anyone used

RE: db file sequential reads

is that the I/O is too slow ? Anjo Kolk http://www.oraperf.com Robertson Lee - lerobe wrote: All, Oracle 8.0.5.0.0 Tru64 4.0f We are having a performance issue with one of our applications and it looks like it is pointing to the db file sequential reads event. I have been doing

Re: db file sequential reads

4.0f We are having a performance issue with one of our applications and it looks like it is pointing to the db file sequential reads event. I have been doing some digging around and a recommendation in a book I have has suggested a possible way to alleviate this is to use

Re: db file sequential reads

Tru64 4.0f We are having a performance issue with one of our applications and it looks like it is pointing to the db file sequential reads event. I have been doing some digging around and a recommendation in a book I have has suggested a possible way to alleviate

DB File Sequential Reads

$waitstat showed me lots of waits for 'data blocks', v$system_event showed me waits for 'db file sequential reads' and 'buffer busy waits'. From v$session_wait, I tracked this down to a single table. v$filestat shows me lot of physical reads for the disk where the datafile holding that table resides

DB File Sequential Reads and Data Block Waits

in v$system_event for 'buffer busy waits' (2 million) and mainly 'db file sequential reads' (9

db file sequential reads

on db file sequential reads (85% of the active waits) No disk I/O problem is detected. Buffer cache hit_ratio = 92.30 % Is it normal to have such amount of waits on db file sequential reads ? SVRMGR select n1.event Event Name, 2 n1.event_count Count, 3 n1