| Data file init write [message #219352] |
Wed, 14 February 2007 02:19  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Hi,
I got an awr report from a customer to analyze. In the top-5 wait events there is this event "Data file init write".
I cannot find anything about this; Google'd, searched this site and Oracle forums.
Does anybody know what exactly this depicts?
|
|
|
|
| Re: Data file init write [message #219389 is a reply to message #219352] |
Wed, 14 February 2007 04:00  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
It's a wait while Oracle formats data blocks.
Do you have any data files that are autoextending?
There are a couple of Forum postings on Metalink about it, but not much information.
|
|
|
|
| Re: Data file init write [message #219390 is a reply to message #219389] |
Wed, 14 February 2007 04:03 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Thanks!
I suspected something like this. Mainly insert on 1 table is not performing, so I thought maybe this was due to this table/datafile extending..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
