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 Micro Focus Operations Smart Plug-in for Oracle Reference Guide for more information about these attributes

 

General

Leading Product:
Operations Bridge Analytics


Secondary Product:
Operations Agent

10/16/2018

Documentation

Documentation for this integration can be found using the following links:

 

Support Matrix

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