top of page

Success is about Imagination
Ignite Your Passion




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....
kyle Hailey
Sep 4, 20133 min read
41 views
0 comments

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...
kyle Hailey
Aug 29, 20135 min read
121 views
0 comments

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...
kyle Hailey
Aug 28, 20132 min read
40 views
0 comments

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...
kyle Hailey
Aug 27, 20137 min read
66 views
0 comments

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...
kyle Hailey
Aug 26, 20131 min read
44 views
0 comments
bottom of page