Home » RDBMS Server » Performance Tuning » Data file init write
Data file init write [message #219352] Wed, 14 February 2007 02:19 Go to next message
Frank
Messages: 7880
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 Go to previous messageGo to next message
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 Go to previous message
Frank
Messages: 7880
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..
Previous Topic: How to approach this
Next Topic: Updating a BIG table
Goto Forum:
  


Current Time: Sat Dec 03 11:54:21 CST 2016

Total time taken to generate the page: 0.17188 seconds