Oracle Database Discussions

"db file sequential read" wait event slowing down a query.

This is a rather strange problem. There is an update statement that hangs on the wait event "db file sequential read" and until the database is restarted, the query runs just fine. It happens once a week, usually on mondays or after several days of high amount of work.

I have checked the processor and is fine, memory is fine although the SGA and PGA have the maximum memory taken. Disk throughput appears to be ok since every other session on the database looks fine.

I assume there is some configuration missing to avoid having to restart the database every week.

Any help is greatly appreciated.