Re: Event 'db file seq. read' stuck for hours on the same file#/block# ?

Haximus wrote:

> Just a thought... latch contention? 'db file seq. read' is for control file
> and datafile header access

Is your advice based on ignorance or intended to do harm?

Source:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/instance_tune.htm#15959

db file sequential read
This event signifies that the user process is reading a buffer into the SGA buffer cache and is waiting for a physical I/O call to return. A sequential read is a single-block read.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)