Search

OakieTags

Who's online

There are currently 0 users and 29 guests online.

Recent comments

Affiliations

Find Objects with the Greatest Wait Time – What is Wrong with this Quote?

June 28, 2011 While reading the alpha edition of the “Oracle Database 11g Performance Tuning Recipes” book, I noticed a couple of interesting SQL statements in Recipe 5-17 that just did not look right.  One of those SQL statements, slightly reformatted, appears below: SELECT   A.CURRENT_OBJ#,   O.OBJECT_NAME,   O.OBJECT_TYPE,   A.EVENT,   SUM(A.WAIT_TIME + [...]