Database Oracle Executive Summary |
DBSPI_ ORA_ REPORT |
DBSPI_ ORA_ REPORT |
|
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 节点)
|
Database Oracle Instance Space Utilization Detail |
DBSPI_ORA_REPORT |
DBSPI_ORA_REPORT |
- 计划任务策略
- DBSPI-Ora-1d-Reporter(适用于 UNIX/Linux 节点)
- DBSPI-Ora-1d-Reporter-NT(适用于 Windows 节点)
|
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 节点)
|