Description

This integration enables users to collect global Oracle database information for use in Operations Bridge Analytics (OBA). After users configure an OMi Management Pack for Oracle Collection from an OBA server host, the collection collects metrics every 15 minutes, with 5 minute granularity.

 

The following metrics are collected (see OMi Management Pack documentation for more details):

E007_TBLSPCSTATUSCNT
E006_TBLSPFREEPCTCNT
E008_TSBREADRATIOCNT
E009_TSTMPEXNTPCTCNT
E011_TBLSPCFRGMNTCNT
E016_SEGMNTEXTENDCNT
E017_SEGMAXEXTENTCNT
E018_SEGEXTRAPIDCNT
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
E076_PQRANGESCANPCT
E044_COMMITRATE
E058_ARCHVFREESPCPCT
E062_BKGRDUMPSPCEPCT
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

The dashboard has been grouped according to the grouping of the "Golden Metrics" specified in the MP documentation.

 

General

Leading Product:
Operations Bridge Analytics


Secondary Product:
Operations Agent

4/29/2019

Documentation

See the OBA Help Center for instructions to set up this collection. 

 

Support Matrix

  Operations Agent
Operations Bridge Analytics
SupportedSupported (see comments)Not Supported