Database Tuning (MOSC)

MOSC Banner

db file async I/O submit

edited Jun 11, 2013 12:32PM in Database Tuning (MOSC) 14 commentsAnswered
 Hi All, 
I have a database at the moment where i am seeing long waits for db file async I/O submit 

It's and 11.2.0.3 database on RHL 5.

The databae is pretty write intensive. 
An AWR for a busy period shows db file async I/O submit  as the top Background wait with long wait times. 

e.g. 
                                                             Avg
                                        %Time Total Wait    wait    Waits   % bg
Event                             Waits -outs   Time (s)    (ms)     /txn   time
-------------------------- ------------ ----- ---------- ------- -------- ------
db file async I/O submit            391     0        389     995      0.0   65.1


This is for a 15 minute snapshot. 
I'm not familiar with this event and have not had much luck searching for information. Any pointers on how to address this would be extrementl gratefully received. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center