Search

OakieTags

more tags

Who's online

There are currently 0 users and 43 guests online.

Recent comments

Affiliations

Home

Wait Events

Missing wait event

Submitted by Timur Akhmadeev on Thu, 2010-05-13 20:39

Oracle 11.2.0.1 for Windows is out for some time. I’ve installed it on my 32-bit Windows XP machine because I like Windows – just to check that it’s actually working fine. Playing with TPC-H test using Hammerora I’ve noticed an anomaly in the way Oracle reports IO waits for some queries. Here is a test [...]

Graphing AWR Data in Excel

Submitted by davidkurtz on Sun, 2010-03-28 21:23
I often use data collected by the Oracle Automatic Workload Repository (AWR) to help to diagnose performance problems. However, I often work on performance problems with application teams, rather than the DBAs.  It is surprising how often that I don't have access to Oracle Enterprise Manager.
Somebody might say that the system was slow at a particular time. I want to get an overview of the database at that time, and I might also want to compare it to another time when the system wasn't slow. Later I may generate AWR reports using particular pairs of snapshots, but I need something to direct me to when an issue occurred, and hence which snapshots to compare.

Oracle Redo Log Waits

Submitted by khailey on Fri, 2010-01-29 21:51



In an ongoing effort to document the main Oracle wait events, here is my current effort at documenting Oracle's redo log related wait events. The original article is at

http://sites.google.com/site/embtdbo

and I will be making additional change and adding content as I have time.