Success is about Imagination

Followup: The tweets from the datachat are available at http://www.confio.com/logicalread/oracle-db-performance-80-percent-hardware-dc01/...

Introduction Unfortunately, what Oracle calls “Network Waits” most often have little to do with Network but and almost exclusively to do...

Oracle 10 and 11 Buffer Busy Waits usually happen on Oracle 10 and 11 mainly because of insert contention into tables or Indexes.  There...

Here are  the tuning metrics tables (SQL  stats are not in “metric” tables per say) (*DBA_HIST_…_HISTORY views are sort of confusing....

Here is a quick table comparison of  different types of metrics views The first line of the table is the classic wait event and statistic...

Primary/Unique Key: inserting a unique key when  someone else has already inserted that key but not committed Foreign Key: Inserting a...

db file sequential read db file scattered read log file parallel write direct path reads direct path reads temp Of course it would be...

Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause on highly concurrent...

Does the query always execute in the same amount of  time? If some executions are slower, what is the slowest execution time? When did...

Image from Bertrand Drouvot UPDATE: thanks to a discussion in the comments it’s come to my attention that there should be some more...

Here is my list and everything on this list is excellent. I’m sure I missed a few good ones, but maybe people can add them in the...