kyle Hailey
Full table scan runs way slower today!
Every so often a DSS query that usually takes 10 minutes ends up taking over an hour. (or one that takes an hour never seems to finish)...
top of page
Kyle Hailey: Imagination Creation
kyle Hailey
- Sep 4, 2013
- 10 min
EM 12c Snap Clone
Oracle OEM 12c introduces a new feature that enables the creation of Oracle database thin clones by leveraging file system snapshot...
0 views0 comments
kyle Hailey
- Sep 4, 2013
- 3 min
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....
1 view0 comments
kyle Hailey
- Sep 3, 2013
- 6 min
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...
1 view0 comments
kyle Hailey
- Aug 30, 2013
- 2 min
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...
0 views0 comments
kyle Hailey
- Aug 29, 2013
- 5 min
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...
0 views0 comments
kyle Hailey
- Aug 28, 2013
- 2 min
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...
0 views0 comments
kyle Hailey
- Aug 28, 2013
- 6 min
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...
1 view0 comments
kyle Hailey
- Aug 27, 2013
- 7 min
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...
1 view0 comments
kyle Hailey
- Aug 26, 2013
- 1 min
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...
1 view0 comments
kyle Hailey
- Aug 23, 2013
- 2 min
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...
2 views0 comments
kyle Hailey
- May 8, 2009
- 1 min
SQL*Net break/reset to client
Another problematic wait event in Oracle is “SQL*Net break/reset to client”. This wait event typically happens when there is something...
4 views0 comments
kyle Hailey
- Apr 30, 2009
- 2 min
Lock Waits: Finding the blocking SQL on Oracle
One of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the...
1 view0 comments
bottom of page