What dimensions are used to identify top SQL in the AWR?
For Top SQL, we collect top SQL on the following dimensions: — CPU Time — Elapsed Time — Parse Calls — Sharable Memory — Version Count When initialization parameter STATISTICS_LEVEL = TYPICAL, we collect the Top 30 SQL statements for each criteria. When STATISTICS_LEVEL = ALL, we collect the top 100 SQL statements for each criteria. For top Segments, we on the following dimensions: — Logical reads — Wait count — RAC stats — Largest space used delta — Round-robin scheme to make sure old space statistics are eventually flushed We capture top 100 top segments for each dimension.
