top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Apr 14, 20141 min read
Performance live discussion on twitter, 12pm PST Tue April 15
Followup: The tweets from the datachat are available at http://www.confio.com/logicalread/oracle-db-performance-80-percent-hardware-dc01/...
4 views0 comments
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, 20133 min read
Metrics vs Statistics
Here are the tuning metrics tables (SQL stats are not in “metric” tables per say) (*DBA_HIST_…_HISTORY views are sort of confusing....
38 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...
31 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...
109 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 28, 20136 min read
Finding the slowest SQL execution of the same query
Does the query always execute in the same amount of time? If some executions are slower, what is the slowest execution time? When did...
74 views0 comments
kyle Hailey
Aug 27, 20137 min read
Oracle CPU Time
Image from Bertrand Drouvot UPDATE: thanks to a discussion in the comments it’s come to my attention that there should be some more...
47 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
bottom of page