gridcontrol 动态表

• 1.查看所有客户端服务状态历史记录

  selecttarget_name        "TargetName",

                     target_type         "Target Type",

                     availability_status "Status",

                     start_timestamp "From Time:",

                     end_timestamp  "To Time"

        from mgmt$availability_history

   orderby target_name, start_timestampdesc;

• 查看主机cpu、内存某日的平均值

  SELECTtarget_name,metric_column,column_label,rollup_timestamp "Date",average "Usage %"

  FROMMGMT$METRIC_DAILY a

  WHERE/*target_name ='acspsgdbaserver-06'

  AND*/ metric_name ='Load'

  ANDmetric_columnin('cpuUtil','memUsedPct')

  AND rollup_timestamp>=sysdate-2;

• 查看GC job

  selectJOB_NAME, STATUS, START_TIME, END_TIME

    fromMGMT$JOB_EXECUTION_HISTORY

    where status ='Succeeded'

    --and JOB_NAME ='RMAN_BACKUP_OF_MYDB'

    orderby START_TIME

• 查看自定义度量：
  MGMT$METRIC_CURRENT
  MGMT$METRIC_HOURLY
  MGMT$METRIC_DAILY
  select*from mgmt$metric_current wherecolumn_label='Current Open CursorsCount';

• 查看磁盘
  SELECT * FROM MGMT$METRIC_CURRENT WHERE metric_name = 'Filesystems' ;