Summary
Integration Catalog
Reference
Description
This integration enables users to collect global Oracle database information for use in Operations Bridge Analytics (OBA). After users configure an Operations Manager Smart Plug-in for Oracle Collection from an OBA server appliance, the Operations Manager Smart Plug-in for Oracle Collection collects events every 15 minutes, with 5 minute granularity.
Examples of the database information that is collected by default include the following:
- HOSTNAME
- AGENTTIMESTAMP
- SOURCE
- SOURCEID
- INSTANCENAME
- E007_TBLSPCSTATUSCNT
- E006_TBLSPFREEPCTCNT
- E008_TSBREADRATIOCNT
- E009_TSTMPEXNTPCTCNT
- E011_TBLSPCFRGMNTCNT
- E016_SEGMNTEXTENDCNT
- E017_SEGMAXEXTENTCNT
- E018_SEGEXTRAPIDCNT
- E067_RBSEGMNTSTATCNT
- E004_USERSTMPDFLTCNT
- E005_OBJCTSFORIGNCNT
- E019_SORTDISKRATE
- E020_SORTMEMORYPCT
- E052_SORTTOTALRATE
- E021_BUFFERBUSYPCT
- E022_TOTBUFCACHITPCT
- E023_CURBUFCACHITPCT
- E026_DICTCACHEHITPCT
- E027_LIBCACHRELODPCT
- E039_LIBCACGETHITPCT
- E040_LIBCACPINHITPCT
- E045_SHRDPOOLFREEPCT
- E059_CURSORCACHEPCT
- E030_FULLGTBLSCNRATE
- E042_UNLYZTBLINDXPCT
- E046_ROWFETCBYIDXPCT
- E070_PQSERVRSBUSYPCT
- E071_PQSRVHIGHWTRPCT
- E074_PQQUERYRATE
- E076_PQRANGESCANPCT
- E044_COMMITRATE
- E058_ARCHVFREESPCPCT
- E060_REDOUNARCHVDCNT
- E062_BKGRDUMPSPCEPCT
- E063_TRACEFILEADDCNT
- E064_USERDUMPSPACPCT
- E065_COREDUMPSPACPCT
- E037_USERLOGONCNT
- E082_SESSHIGHWATRCNT
- E002_PROCESSSTATUS
- E051_SORTROWSAVGCNT
- E041_FULSHTBLSCNRATE
- E047_TABLESCACHEDCNT
- E048_CHANDROWFTCHPCT
- E054_ROLLBACKRATE
- E085_TRANSACTIONPCT
- E056_ARCHVFREESPCCNT
- E057_ARCHIVEFREQRATE
- E066_ALERTLOGSIZE
- E028_LOCKSUSEDPCT
- E029_SESSWAITLCKCNT
- E097_DISBLDTBLLCKNUM
- E032_REDOLGSPCREQCNT
- E033_REDOALOCLTCHPCT
- E034_REDOCOPYLTCHPCT
- E024_EQWAITSREQPCT
- E038_LTCHOVRLIMITCNT
- E043_EQTIMEOUTREQPCT
- E089_ENQUEUEPCT
- E049_USERCALLRATE
- E050_RCSVUSRCALRATIO
- E075_RCRSVCURSRRATIO
- E090_DSPTCHRBUSYPCT
- E091_NUMDSPTCHRCLNTS
- E092_SHRSRVRREQWTPCT
- E093_SHAREDSERVERPCT"
- E094_SESUGAMEMCURPCT
- E095_SESUGAMEMMAXPCT
- E096_SHRDSRVHWMPCT
- E086_PHYSREADSRATE
- E088_LOGICREADSRATE
- E035_BCKGNDCKPTRATE
- E083_DBWRCKPTRATE
- E068_RBSGMNTSHRNKCNT
- E069_RBSEGWAITPCTCNT
- E031_OPENCRSRPCTCNT
- E087_PROCESSPCT
See HPE Operations Smart Plug-in for Oracle Reference Guide for more information about these attributes
General
Leading Product:
Operations Bridge Analytics (prev. Ops Analytics)
Secondary Product:
Operations Agent
4/14/2018
Documentation
Documentation for this integration can be found using the following links:
Support Matrix
| Operations Agent | ||
| Operations Bridge Analytics (prev. Ops Analytics) | ||
Generated: 6/11/2018 4:46:47 AM