Lesson Summary
- Analyze historical SQL performance using M_EXPENSIVE_STATEMENTS to identify resource-intensive SQL executions exceeding defined thresholds.
- Pinpoint the occurrence of out-of-memory (OOM) events with M_OUT_OF_MEMORY_EVENTS to establish a fluctuation timeframe.
- Examine HOST_SQL_PLAN_CACHE for historical execution plan statistics, focusing on max_execution_time, to identify performance fluctuations over time.
- Correlating data from these monitoring views will help you determine the performance fluctuation timeframe, focusing your investigation on specific periods of degradation or improvement.
- Cross-reference user reports with monitoring view data to validate and refine the identified performance fluctuation timeframe.