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 HaileySep 3, 20136 minWait Metrics vs Wait EventsHere is a quick table comparison of different types of metrics views The first line of the table is the classic wait event and statistic...
kyle HaileyAug 30, 20132 minEnqueue – 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...
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...