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
Read MoreHere are the tuning metrics tables (SQL stats are not in “metric” tables per say) (*DBA_HIST_…_HISTORY views are sort of
Read MoreHere is a quick table comparison of different types of metrics views The first line of the table is the
Read MoreIf one is seeing waits for enq: TX – row lock contention then there could be a lot of reasons. One
Read MoreOne thing that I have found sorely missing in the performance pages of Enterprise Manager is latency values for various
Read MoreAnyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause
Read MoreImage from Bertrand Drouvot UPDATE: thanks to a discussion in the comments it’s come to my attention that there should
Read MoreSeeing more and more questions on “where do I start with Oracle if I want to be a DBA?” My
Read MoreHow do we know where latency comes from when there is a disparity in reported I/O latency on the I/O
Read MoreOracle has a crazy mix of units of time in various v$ views seconds centi-seconds milliseconds microseconds Some are straight
Read More