Re: lots of waiting on 'db file parallel write'

Advance search metalink for "db file parallel write" for starters.

Check out v$bh - you may be thrashing buffers, interfering with the db writers ability to finish the i/o they have to do. With the large SGA you have, Oracle will consider larger tables as MRU, effectively caching them for full table scans. These tables should be moved to keep or recycle pools, as appropriate.

But don't ignore those sequential reads - are you _sure_ you've tuned your app as much as you can? Are you sure those undo header waits aren't happening during the slowdowns? Are you sure Veritas isn't doing some housekeeping?

jg

--
@home.com is bogus.
http://www.businessweek.com/innovate/content/feb2006/id20060224_155318.htm