DECLARE
  l_cursor  DBMS_SQLTUNE.sqlset_cursor;
BEGIN
  OPEN l_cursor FOR
    SELECT VALUE(p)
    FROM   TABLE (DBMS_SQLTUNE.select_workload_repository (
                    2620,  -- begin_snap
                    2627,  -- end_snap
                    NULL, -- basic_filter
                    NULL, -- object_filter
                    NULL, -- ranking_measure1
                    NULL, -- ranking_measure2
                    NULL, -- ranking_measure3
                    NULL, -- result_percentage
                    10)   -- result_limit
                  ) p;

  DBMS_SQLTUNE.load_sqlset (
    sqlset_name     => 'test_sql_tuning_set',
    populate_cursor => l_cursor);
END;

SELECT * FROM V$ACTIVE_SESSION_HISTORY; -- Displays the active session history (ASH) sampled every second.
SELECT * FROM V$METRIC; -- Displays metric information.
SELECT * FROM V$METRICNAME; -- Displays the metrics associated with each metric group.
SELECT * FROM V$METRIC_HISTORY; -- Displays historical metrics.
SELECT * FROM V$METRICGROUP; -- Displays all metrics groups.
SELECT * FROM DBA_HIST_ACTIVE_SESS_HISTORY; -- Displays the history contents of the active session history.
SELECT * FROM DBA_HIST_BASELINE; -- Displays baseline information.
SELECT * FROM DBA_HIST_DATABASE_INSTANCE; -- Displays database environment information.
SELECT * FROM DBA_HIST_SNAPSHOT; -- Displays snapshot information.
SELECT * FROM DBA_HIST_SQL_PLAN; -- Displays SQL execution plans.
SELECT * FROM DBA_HIST_WR_CONTROL; -- Displays AWR settings.