Oracle Wait Events

When writing posts on performance tuning I felt that there needs to be a my-version of description of Oracle Wait Events along with Access method and Process & Memory Architecture. Thus this series is to start the Oracle Wait events which are common in any Database Environment BUT has a lot of story.

  1. db file scattered read – oracle wait event
  2. db file sequential reads – Oracle wait event
  3. Direct Path Read/Direct Path Read Temp – Oracle Wait Event
  4. Buffer busy waits – Oracle Wait Event
  5. Library Cache lock – Oracle Wait Event
  6. Library Cache Pin – Oracle Wait Event
  7. log file switch – Oracle Wait Event
  8. log file sync – Oracle Wait Event
  9. row cache lock – Oracle Wait Event

 

These posts are mainly to build knowledge base for my Performance Tuning Series, but in case you want me to cover any specific wait event please feel free to add your comments below.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s