Oracle Database 报告的先决条件策略

策略配置要求:非必需;使用默认设置部署策略。

报告名称 数据源 数据类 SPI 策略
Database Oracle Executive Summary DBSPI_ ORA_ REPORT DBSPI_ ORA_ REPORT
  • 计划任务策略
    • DBSPI-Ora-05min-Reporter(适用于 UNIX/Linux 节点)

    • DBSPI-Ora-05min-Reporter-NT(适用于 Windows 节点)
  • 测量阈值策略

    • E201_InstUptime
Database Oracle Top 10 Instances and Tablespaces DBSPI_ORA_REPORT DBSPI_ORA_REPORT
  • 计划任务策略
    • DBSPI-Ora-05min-Reporter(适用于 UNIX/Linux 节点)
    • DBSPI-Ora-1d-Reporter(适用于 UNIX/Linux 节点)
    • DBSPI-Ora-05min-Reporter-NT(适用于 Windows 节点)
    • DBSPI-Ora-1d-Reporter-NT(适用于 Windows 节点)
  • 测量阈值策略

    • E201_InstUptime
    • E210_TblSpcSize
    • E212_Inst Size
Database Oracle Top 5 Instances Load and Efficiency DBSPI_ORA_GRAPH DBSPI_ORA_GRAPH
  • 计划任务策略
    • DBSPI-Ora-05min-Favorites
    • DBSPI-Ora-Add-Ons-05min
    • DBSPI-Ora-05min-SQLNet
    • DBSPI-Ora-1h-Favorites
    • DBSPI-Ora-1h-SQLNet
    • DBSPI-Ora-05min-Favorites
  • 测量阈值策略
    • E021_BufferBusyPct
    • E022_TotBufCacHitPct
    • E039_LibCacGetHitPct
    • E032_REDOLGSPCREQCNT
    • E019_SortDiskRate
    • E020_SortMemoryPct
    • E037_UserLogonCnt
    • E049_USERCALLRATE
Database Oracle Archive Device Detail DBSPI_ORA_GRAPH DBSPI_ORA_GRAPH
  • 计划任务策略
    • DBSPI-Ora-15min-Favorites
    • DBSPI-Ora-05min-Favorites
    • DBSPI-Ora-05min-SQLNet
    • DBSPI-Ora-Add-Ons-15min
    • DBSPI-Ora-1h-SQLNet
    • DBSPI-Ora-Add-Ons-15min-NT(适用于 Windows 节点)
  • 测量阈值策略
    • E058_ArchvFreeSpcPct
    • E060_RedoUnarchvdCnt
    • E062_BkgrDumpSpcePct
    • E063_TraceFileAddCnt
    • E064_UserDumpSpacPct
    • E065_CoreDumpSpacPct
Database Oracle Disk And Memory Sort Detail DBSPI_ORA_GRAPH DBSPI_ORA_GRAPH
  • 计划任务策略
    • DDBSPI-Ora-1h-Favorites
    • DBSPI-Ora-1h-SQLNet
    • DBSPI-Ora-Add-Ons-05min
    • DBSPI-Ora-05min-SQLNet
    • DBSPI-Ora-Add-Ons-1h
    • DBSPI-Ora-1h-SQLNet
    • DBSPI-Ora-Add-Ons-1h-NT
  • 测量阈值策略
    • E019_SortDiskRate
    • E020_SortMemoryPct
    • E052_SortTotalRate
Database Oracle Instance Availability Detail DBSPI_ORA_REPORT DBSPI_ORA_REPORT
  • 计划任务策略
    • DBSPI-Ora-05min-Reporter(适用于 UNIX/Linux 节点)
    • DBSPI-Ora-05min-Reporter-NT(适用于 Windows 节点)
  • 测量阈值策略
    • E201_InstUptime
Database Oracle Instance Space Utilization Detail DBSPI_ORA_REPORT DBSPI_ORA_REPORT
  • 计划任务策略
    • DBSPI-Ora-1d-Reporter(适用于 UNIX/Linux 节点)
    • DBSPI-Ora-1d-Reporter-NT(适用于 Windows 节点)
  • 测量阈值策略
    • E212_Inst Size
Database Oracle Segment Detail DBSPI_ORA_GRAPH DBSPI_ORA_GRAPH
  • 计划任务策略
    • DBSPI-Ora-15min-SQLNet
    • DBSPI-Ora-15min-Favorites
    • DBSPI-Ora-05min-Favorites
    • DBSPI-Ora-05min-SQLNet
  • 测量阈值策略
    • E016_SegmntExtendCnt
    • E017_SegMaxExtentCnt
    • E018_SegExtRapidCnt
    • E067_RBSegmntStatCnt
Database Oracle Shared Pool and Cache Performance Detail DBSPI_ORA_GRAPH DBSPI_ORA_GRAPH
  • 计划任务策略
    • DBSPI-Ora-05min-Favorites
    • DBSPI-Ora-Add-Ons-05min
    • DBSPI-Ora-05min-SQLNet
    • DBSPI-Ora-Add-Ons-05min-NT
    • DBSPI-Ora-05min-SQLNet
  • 测量阈值策略
    • E021_BufferBusyPct
    • E022_TotBufCacHitPct
    • E039_LibCacGetHitPct
    • E026_DictCacheHitPct
    • E040_LibCacPinHitPct
    • E045_ShrdPoolFreePct
Database Oracle SQL Performance Detail DBSPI_ORA_GRAPH DBSPI_ORA_GRAPH
  • 计划任务策略
    • DBSPI-Ora-05min-Favorites
    • DBSPI-Ora-05min-SQLNet
    • DBSPI-Ora-Add-Ons-1h-NT
    • DBSPI-Ora-1h-SQLNet
    • DBSPI-0070
    • DBSPI-0071
    • DBSPI-0074
    • DBSPI-0076
  • 测量阈值策略
    • E030_FulLgTblScnRate
    • E046_RowFetcByIdxPct
    • E070_PQServrsBusyPct
    • E071_PQSrvHighwtrPct
    • E074_PQQueryRate
    • E076_PQRangeScanPct
Database Oracle Tablespace Detail DBSPI_ORA_GRAPH DBSPI_ORA_GRAPH
  • 计划任务策略
    • DBSPI-Ora-05min-Favorites
    • DBSPI-Ora-05min-SQLNet
    • DBSPI-0006
    • DBSPI-Ora-1h-Favorites
    • DBSPI-Ora-Add-Ons-05min
    • DBSPI-Ora-Add-Ons-05min-NT
  • 测量阈值策略
    • E007_TblSpcStatusCnt
    • E006_TblSpFreePctCnt
    • E008_TSBReadRatioCnt
    • E004_UsersTmpDfltCnt
    • E005_ObjctsForignCnt
    • E011_TblSpcFrgmntCnt
Database Oracle Tablespace Space Utilization Detail DBSPI_ORA_REPORT DBSPI_ORA_REPORT
  • 计划任务策略
    • DBSPI-Ora-1d-Reporter(适用于 UNIX/Linux 节点)
    • DBSPI-Ora-1d-Reporter-NT(适用于 Windows 节点)
  • 测量阈值策略
    • E210_TblSpcSize