eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.INT$DBA_HIST_BASELINE

Source

View Text - Preformatted


select bl.dbid, bl.baseline_id,
       bl.baseline_name, max(bl.baseline_type),
       min(bst.start_snap_id), min(bst.start_snap_time),
       max(bst.end_snap_id),   max(bst.end_snap_time),
       max(bl.moving_window_size), max(bl.creation_time),
       max(bl.expiration), max(bl.template_name),
       max(bl.last_time_computed), con_dbid_to_id(bl.dbid) con_id
from
  WRM$_BASELINE bl, WRM$_BASELINE_DETAILS bst
where
  bl.dbid = bst.dbid and
  bl.baseline_id != 0 and
  bl.baseline_id = bst.baseline_id
group by bl.dbid, bl.baseline_id, baseline_name
union all
select bl.dbid, bl.baseline_id,
       bl.baseline_name, max(bl.baseline_type),
       min(bst.start_snap_id), min(bst.start_snap_time),
       max(bst.end_snap_id),   max(bst.end_snap_time),
       max(bl.moving_window_size), max(bl.creation_time),
       max(bl.expiration), max(bl.template_name),
       max(bl.last_time_computed), con_dbid_to_id(bl.dbid) con_id
from
  WRM$_BASELINE bl,  /* Note: moving window stats only for local dbid */
  table(dbms_workload_repository.select_baseline_details(bl.baseline_id)) bst
where
  bl.dbid = bst.dbid and
  bl.baseline_id = 0 and
  bl.baseline_id = bst.baseline_id
group by bl.dbid, bl.baseline_id, baseline_name

View Text - HTML Formatted

SELECT BL.DBID
, BL.BASELINE_ID
, BL.BASELINE_NAME
, MAX(BL.BASELINE_TYPE)
, MIN(BST.START_SNAP_ID)
, MIN(BST.START_SNAP_TIME)
, MAX(BST.END_SNAP_ID)
, MAX(BST.END_SNAP_TIME)
, MAX(BL.MOVING_WINDOW_SIZE)
, MAX(BL.CREATION_TIME)
, MAX(BL.EXPIRATION)
, MAX(BL.TEMPLATE_NAME)
, MAX(BL.LAST_TIME_COMPUTED)
, CON_DBID_TO_ID(BL.DBID) CON_ID FROM WRM$_BASELINE BL
, WRM$_BASELINE_DETAILS BST WHERE BL.DBID = BST.DBID AND BL.BASELINE_ID != 0 AND BL.BASELINE_ID = BST.BASELINE_ID GROUP BY BL.DBID
, BL.BASELINE_ID
, BASELINE_NAME UNION ALL SELECT BL.DBID
, BL.BASELINE_ID
, BL.BASELINE_NAME
, MAX(BL.BASELINE_TYPE)
, MIN(BST.START_SNAP_ID)
, MIN(BST.START_SNAP_TIME)
, MAX(BST.END_SNAP_ID)
, MAX(BST.END_SNAP_TIME)
, MAX(BL.MOVING_WINDOW_SIZE)
, MAX(BL.CREATION_TIME)
, MAX(BL.EXPIRATION)
, MAX(BL.TEMPLATE_NAME)
, MAX(BL.LAST_TIME_COMPUTED)
, CON_DBID_TO_ID(BL.DBID) CON_ID FROM WRM$_BASELINE BL
, /* NOTE: MOVING WINDOW STATS ONLY FOR LOCAL DBID */ TABLE(DBMS_WORKLOAD_REPOSITORY.SELECT_BASELINE_DETAILS(BL.BASELINE_ID)) BST WHERE BL.DBID = BST.DBID AND BL.BASELINE_ID = 0 AND BL.BASELINE_ID = BST.BASELINE_ID GROUP BY BL.DBID
, BL.BASELINE_ID
, BASELINE_NAME