Success is about Imagination

Ignite Your Passion

kyle Hailey

Mar 24, 20144 min read

Oracle SQL*Net Wait Events

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

46 views0 comments

kyle Hailey

Mar 21, 201410 min read

Oracle : buffer busy wait

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

21 views0 comments

kyle Hailey

Sep 3, 20136 min read

Wait Metrics vs Wait Events

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...

32 views0 comments

kyle Hailey

Aug 30, 20132 min read

Enqueue – PK, FK or Bitmap Index problem?

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

14 views0 comments

kyle Hailey

Aug 29, 20135 min read

Oracle I/O latency monitoring

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

110 views0 comments

kyle Hailey

Aug 28, 20132 min read

CURSOR_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 on highly concurrent...

27 views0 comments

kyle Hailey

Aug 26, 20131 min read

Where to begin with Oracle and SQL

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...

40 views0 comments

kyle Hailey

Aug 23, 20132 min read

Oracle 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 forward...

26 views0 comments