Description of the SQL Performance Summary Chart
This image is a screen capture of the SQL Performance Summary chart showing the heat map. The fields above the map show the following selections:
- Group By - Databases
- Size - CPU Time
- Color - % Change Value
- in - CPU Time
The SQLs are grouped by these databases - rac121 and db302.
The SQL that is selected in the Heat Map is 9zg9qd9bm4spu.
The bar chart below the heat map displays the details of the SQL '9zg9qd9bm4spu' grouped by the databases 'rac121' and 'db302'.
- The x-axis shows the dates from 5 August to 4 September 2018. The y-axis shows the Average Response Times (secs), in increments of 1.0, from 0.0 to 4.0.
- The blue bars represent the database 'rac121' and the green bars represent 'db302'.
- 'rac121' shows the highest average response time of (approx.) 4.0 secs on 8 August and the lowest average response time of 2.0 secs on 7 and 10 August.
- The average response time for 'db302' is 1.0 secs on 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 24, 28, and 31 August; and again on 3 September.