Oracle SQL*Net Wait Events
Introduction Unfortunately, what Oracle calls “Network Waits” most often have little to do with Network but and almost exclusively
Read More
Making Technology Bulletproof
wait events
Oracle : buffer busy wait
Oracle 10 and 11 Buffer Busy Waits usually happen on Oracle 10 and 11 mainly because of insert contention
Read MoreWait Metrics vs Wait Events
Here is a quick table comparison of different types of metrics views The first line of the table is the
Read MoreEnqueue – PK, FK or Bitmap Index problem?
If one is seeing waits for enq: TX – row lock contention then there could be a lot of reasons. One
Read MoreOracle I/O latency monitoring
One thing that I have found sorely missing in the performance pages of Enterprise Manager is latency values for various
Read MoreCURSOR_SHARING : a picture is worth a 1000 words
Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause
Read MoreWhere to begin with Oracle and SQL
Seeing more and more questions on “where do I start with Oracle if I want to be a DBA?” My
Read MoreOracle time units in V$ views
Oracle has a crazy mix of units of time in various v$ views seconds centi-seconds milliseconds microseconds Some are straight
Read More