How to find the average active sessions between 2 dates.
SELECT rollup_timestamp, average, minimum, maximum FROM mgmt$metric_daily WHERE target_name = 'TRCOPDOV' AND metric_label = 'Throughput' AND column_label = 'Average Active Sessions' AND rollup_timestamp BETWEEN TO_DATE ('01/11/2015', 'dd/mm/yyyy') AND TO_DATE ('01/12/2015', 'dd/mm/yyyy') ORDER BY 1;