kyle HaileySep 4, 20133 minMetrics vs StatisticsHere are the tuning metrics tables (SQL stats are not in “metric” tables per say) (*DBA_HIST_…_HISTORY views are sort of confusing....
kyle HaileyAug 29, 20135 minOracle I/O latency monitoringdb file sequential read db file scattered read log file parallel write direct path reads direct path reads temp Of course it would be...
kyle HaileyAug 28, 20132 minCURSOR_SHARING : a picture is worth a 1000 wordsAnyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause on highly concurrent...
kyle HaileyAug 27, 20137 minOracle CPU TimeImage from Bertrand Drouvot UPDATE: thanks to a discussion in the comments it’s come to my attention that there should be some more...
kyle HaileyAug 26, 20131 minWhere to begin with Oracle and SQLHere 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...