Success is about Imagination

Ignite Your Passion

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

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

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

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

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