-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com

-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.

SELECT

-- CAST(begin_interval_time AS DATE) begin_time

begin_time

, metric_name

, metric_unit

, average / 100

FROM

dba_hist_snapshot

NATURAL JOIN

dba_hist_sysmetric_summary

WHERE

-- metric_name IN ('User Commits Per Sec', 'User Transaction Per Sec')

-- metric_name IN ('Physical Read IO Requests Per Sec', 'Physical Write IO Requests Per Sec')

-- metric_name IN ('Host CPU Utilization (%)')

-- metric_name IN ('Logons Per Sec')

REGEXP_LIKE(metric_name, '&1','i')

AND begin_interval_time > SYSDATE - 1

ORDER BY

metric_name

, begin_time

/