All MIBs › EMPIRE-ORAMOD
Category: Domain: Server/Host Monitoring, Vendor: Empire/SystemEDGE, Web and Application Servers
Description: Empire SystemEDGE Oracle module MIB for monitoring Oracle database instance health, sessions, and performance metrics.
Start monitoring vendor-neutral, standards-based MIB, any SNMPv3-capable network device (SNMP engine identity/boot/clock status) with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.
What Is EMPIRE-ORAMOD?
EMPIRE-ORAMOD is a CA/Empire (SystemEDGE agent, enterprise OID 546 under the CONCORD/Empire tree) proprietary MIB monitoring an Oracle database instance's resource consumption via the Empire monitoring agent's Oracle module. Its objects report the module's version and mode, an Oracle-related status flag, and aggregate CPU time, CPU percentage, memory size, resident-set size, memory percentage, and thread count totals for monitored Oracle processes. As a software-performance MIB it lets an administrator watch an Oracle instance's aggregate CPU and memory consumption through the same SNMP-based monitoring used for other Empire-agent-covered resources. It is deployed on servers running an Oracle database monitored by the CA/Empire SystemEDGE agent. Engineers can download the EMPIRE-ORAMOD file directly to load it into their MIB browser.
IPNetwork Monitor allows you to monitor SNMP objects defined in EMPIRE-ORAMOD. Use the built-in SNMP Monitoring Browser to explore available variables, view their current values and descriptions, and select the objects you want to monitor. You can then create SNMP monitors, configure thresholds, and receive alerts when monitored values change.
Supported Devices
- Servers running Oracle databases monitored by the CA/Empire SystemEDGE agent
Monitoring Examples
An administrator monitors oramodTtlPERCENTCPU and oramodTtlPERCENTMEM to catch an Oracle instance's aggregate resource consumption trending upward before it affects overall server performance.
What Can Be Monitored
- Oracle instance aggregate CPU/memory/thread consumption
This MIB depends on
Related MIBs
Imported Objects
From RFC-1212
| OBJECT-TYPE |
From RFC-1215
| TRAP-TYPE |
From RFC1155-SMI
| Counter | |
| Gauge | |
| TimeTicks | |
| enterprises |
From RFC1213-MIB
| DisplayString |
OIDs
| OID symbolic | OID numeric | Type | Access | Description |
|---|---|---|---|---|
| empire | 1.3.6.1.4.1.546 | |||
| applications | 1.3.6.1.4.1.546.16 | |||
| oracledb | 1.3.6.1.4.1.546.16.4 | |||
| STR oraModVersion | 1.3.6.1.4.1.546.16.4.1 | DisplayString | read-only | Description and version number of this installation. |
| INT oraModMode | 1.3.6.1.4.1.546.16.4.2 | INTEGER | read-only | This object indicates if the Oracle Module is in full-mode or restricted-mode. Restricted-mode is entered, when SystemEDGE 4.0 and higher, fails to find a valid license. Once a valid license has been allocated and set, the module will then transition to fullMode(1) |
| STR oraFlag | 1.3.6.1.4.1.546.16.4.3 | DisplayString | read-only | Performance flags for this installation. |
| oramodCfg | 1.3.6.1.4.1.546.16.4.10 | |||
| oramodDbCfg | 1.3.6.1.4.1.546.16.4.10.1 | |||
| oramodDbCfgTable | 1.3.6.1.4.1.546.16.4.10.1.1 | not-accessible | This table describes the instance names, index numbers and initial startup information. | |
| oramodDbCfgEntry | 1.3.6.1.4.1.546.16.4.10.1.1.1 | not-accessible | An entry in the Oracle Configuration table. | |
| INT oramodDbCfgSIDINDX | 1.3.6.1.4.1.546.16.4.10.1.1.1.1 | INTEGER | read-only | Sid's Index Number. |
| STR oramodDbCfgSID | 1.3.6.1.4.1.546.16.4.10.1.1.1.2 | DisplayString | read-only | Database Name. |
| STR oramodDbCfgVERSION | 1.3.6.1.4.1.546.16.4.10.1.1.1.3 | DisplayString | read-only | Description and version of this Oracle installation from v$version |
| STR oramodDbCfgHOME | 1.3.6.1.4.1.546.16.4.10.1.1.1.4 | DisplayString | read-only | The Installation Directory for Oracle or ORACLEHOME. |
| STR oramodDbCfgBASE | 1.3.6.1.4.1.546.16.4.10.1.1.1.5 | DisplayString | read-only | The Base Directory for Oracle or ORACLEBASE. |
| INT oramodDbCfgID | 1.3.6.1.4.1.546.16.4.10.1.1.1.6 | INTEGER | read-only | The database ID calculated when the database is created and stored in all file headers (521382036). |
| STR oramodDbCfgCRTDT | 1.3.6.1.4.1.546.16.4.10.1.1.1.7 | DisplayString | read-only | The original creation date and time of the database. |
| STR oramodDbCfgLOGMODE | 1.3.6.1.4.1.546.16.4.10.1.1.1.8 | DisplayString | read-only | The Archive log mode: NOARCHIVELOG or ARCHIVELOG. |
| STR oramodDbCfgCTRLFILETYPE | 1.3.6.1.4.1.546.16.4.10.1.1.1.9 | DisplayString | read-only | Control File Type. Can be the following types : CURRENT,STANDBY,CLONE,BACKUP,CREATED. |
| STR oramodDbCfgOPENMODE | 1.3.6.1.4.1.546.16.4.10.1.1.1.10 | DisplayString | read-only | Shows whether the database is set to READ WRITE or READ ONLY (NEW TO 8i.). |
| INT oramodDbCfgMAXPROCESS | 1.3.6.1.4.1.546.16.4.10.1.1.1.11 | INTEGER | read-only | For a multiple-process operation, this parameter specifies the maximum number of user processes that can simultaneously connect to an Oracle server. The PROCESSES parameter is used to derive the SESSIONS INIT.ORA parameter. The default is 50. Typical range 6 - OS/dependent |
| INT oramodDbCfgMAXSESSION | 1.3.6.1.4.1.546.16.4.10.1.1.1.12 | INTEGER | read-only | Maximum number of User and System Sessions. |
| STR oramodDbCfgTIMEDSTATISTICS | 1.3.6.1.4.1.546.16.4.10.1.1.1.13 | DisplayString | read-only | TRUE/FALSE: sets timing on. Should be false for maximum performance. |
| INT oramodDbCfgCPUCNT | 1.3.6.1.4.1.546.16.4.10.1.1.1.14 | INTEGER | read-only | The maximum number of CPU's for this instance. |
| INT oramodDbCfgSHAREDPOOLSIZE | 1.3.6.1.4.1.546.16.4.10.1.1.1.15 | INTEGER | read-only | Shared Pool Size Size in Kbytes. Controls the size of the memory area used for parsing and executing SQL statements. The default is 3.5 Mbytes. Typical Range 300 Kbytes. It is O/S dependent. |
| INT oramodDbCfgSHAREDPOOLRSSIZE | 1.3.6.1.4.1.546.16.4.10.1.1.1.16 | INTEGER | read-only | Shared Pool Reserved Size Kbytes. |
| INT oramodDbCfgLARGEPOOLSIZE | 1.3.6.1.4.1.546.16.4.10.1.1.1.17 | INTEGER | read-only | Large Pool Reserved Size Kbytes. |
| INT oramodDbCfgJAVAPOOLSIZE | 1.3.6.1.4.1.546.16.4.10.1.1.1.18 | INTEGER | read-only | Java Pool Size in Kbytes Default is (20000K) |
| STR oramodDbCfgCNTRLFILES | 1.3.6.1.4.1.546.16.4.10.1.1.1.19 | DisplayString | read-only | Name and path of control files. String of file names. |
| INT oramodDbCfgDBBLKBUFF | 1.3.6.1.4.1.546.16.4.10.1.1.1.20 | INTEGER | read-only | Number of Database Block Buffers in blocks. Controls how much memory is available in the buffer cache for data blocks. Default is (26240) |
| INT oramodDbCfgDBBLKSIZE | 1.3.6.1.4.1.546.16.4.10.1.1.1.21 | INTEGER | read-only | Size of Database Blocks. O/S dependent |
| INT oramodDbCfgCKPTINTRVL | 1.3.6.1.4.1.546.16.4.10.1.1.1.22 | INTEGER | read-only | Redo Log Checkpoint Interval. |
| INT oramodDbCfgDBFILES | 1.3.6.1.4.1.546.16.4.10.1.1.1.23 | INTEGER | read-only | Maximum Number of Database Files. |
| INT oramodDbCfgSORTAREASIZE | 1.3.6.1.4.1.546.16.4.10.1.1.1.24 | INTEGER | read-only | Maximum Sort Area Size. Controls the amount of memory allocated to each process in the Process Global Area for any sorting activity (for multithreaded server this is allocated in the shared pool). When a process needs more memory than is available for a sort, disk space must be allocated in the temporary tablespace. Tuning is based on the transaction mix of the application. The default (O/S dependent) is adequate for most DB operations. |
| INT oramodDbCfgOPENCURSORS | 1.3.6.1.4.1.546.16.4.10.1.1.1.25 | INTEGER | read-only | Maximum open cursors a single-user process can have at once. Typical Range (1 - 2147483647). |
| INT oramodDbCfgTRNSACTNS | 1.3.6.1.4.1.546.16.4.10.1.1.1.26 | INTEGER | read-only | Maximum number of concurrent transactions allowed at one time. |
| INT oramodDbCfgTRNSACTNSPERSEG | 1.3.6.1.4.1.546.16.4.10.1.1.1.27 | INTEGER | read-only | Maximum number of concurrent transactions per segment. Default is 30. O/S dependent. |
| INT oramodDbCfgMAXROLLSEG | 1.3.6.1.4.1.546.16.4.10.1.1.1.28 | INTEGER | read-only | Maximum number of rollback segments. |
| oramodCfgDf | 1.3.6.1.4.1.546.16.4.10.2 | |||
| oramodCfgDfTable | 1.3.6.1.4.1.546.16.4.10.2.1 | not-accessible | This table describes the database files for the database. | |
| oramodCfgDfEntry | 1.3.6.1.4.1.546.16.4.10.2.1.1 | not-accessible | An entry in the Oracle v$datafile table. | |
| INT oramodCfgDfSIDINDX | 1.3.6.1.4.1.546.16.4.10.2.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodCfgDfFILENUM | 1.3.6.1.4.1.546.16.4.10.2.1.1.2 | INTEGER | read-only | File Identification Number. |
| STR oramodCfgDfSTATUS | 1.3.6.1.4.1.546.16.4.10.2.1.1.3 | DisplayString | read-only | Type of file (system or user) and its status. Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF(an offline file from the SYSTEM tablespace). |
| STR oramodCfgDfENABLED | 1.3.6.1.4.1.546.16.4.10.2.1.1.4 | DisplayString | read-only | Describes how accessible the file is from SQL. Can be DISABLED, READ ONLY, READ WRITE and UNKNOWN. |
| INT oramodCfgDfUNRCVRBLECHG | 1.3.6.1.4.1.546.16.4.10.2.1.1.5 | INTEGER | read-only | The last unrecoverbale change number made to this datafile. Always updated when an unrecoverable operation completes. |
| INT oramodCfgDfUNRCVRBLETIME | 1.3.6.1.4.1.546.16.4.10.2.1.1.6 | INTEGER | read-only | The last unrecoverbale change time made to this datafile. Always updated when an unrecoverable operation completes. |
| INT oramodCfgDfKBYTES | 1.3.6.1.4.1.546.16.4.10.2.1.1.7 | INTEGER | read-only | Current size in kbytes; 0 if unaccessible. |
| INT oramodCfgDfCRTKBYTES | 1.3.6.1.4.1.546.16.4.10.2.1.1.8 | INTEGER | read-only | Size when created. |
| STR oramodCfgDfFNAME | 1.3.6.1.4.1.546.16.4.10.2.1.1.9 | DisplayString | read-only | Name of the file. |
| STR oramodCfgDfCRTTIME | 1.3.6.1.4.1.546.16.4.10.2.1.1.10 | DisplayString | read-only | Time at which the datafile was created. |
| INT oramodCfgDfTBLESPACENUM | 1.3.6.1.4.1.546.16.4.10.2.1.1.11 | INTEGER | read-only | Tablespace Number. |
| INT oramodCfgDfTBLESPACERFILENUM | 1.3.6.1.4.1.546.16.4.10.2.1.1.12 | INTEGER | read-only | Tablespace Relative Df Number. |
| INT oramodCfgDfBLOCKS | 1.3.6.1.4.1.546.16.4.10.2.1.1.13 | INTEGER | read-only | Current datafile size in blocks; 0 if inaccessible. |
| INT oramodCfgDfBLOCKSIZE | 1.3.6.1.4.1.546.16.4.10.2.1.1.14 | INTEGER | read-only | Block size of the datafile. |
| INT oramodCfgDfERROR | 1.3.6.1.4.1.546.16.4.10.2.1.1.15 | INTEGER | read-only | NULL if the header read success. If error must restore. |
| STR oramodCfgDfRECOVER | 1.3.6.1.4.1.546.16.4.10.2.1.1.16 | DisplayString | read-only | YES/NO File needs media recovery. |
| INT oramodCfgDfRSTLOGSCHGNUM | 1.3.6.1.4.1.546.16.4.10.2.1.1.17 | INTEGER | read-only | Reset Logs change number. |
| STR oramodCfgDfRSTLOGSTIME | 1.3.6.1.4.1.546.16.4.10.2.1.1.18 | DisplayString | read-only | Reset Logs timestamp. |
| oramodCfgLf | 1.3.6.1.4.1.546.16.4.10.3 | |||
| oramodCfgLfTable | 1.3.6.1.4.1.546.16.4.10.3.1 | not-accessible | This table describes the redo log files locations for each Oracle installation from v$logfile. | |
| oramodCfgLfEntry | 1.3.6.1.4.1.546.16.4.10.3.1.1 | not-accessible | An entry in the Oracle Logfile table. | |
| INT oramodCfgLfSIDINDX | 1.3.6.1.4.1.546.16.4.10.3.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodCfgLfMEMBERINDX | 1.3.6.1.4.1.546.16.4.10.3.1.1.2 | INTEGER | read-only | Logfile member index. |
| INT oramodCfgLfGROUPNUM | 1.3.6.1.4.1.546.16.4.10.3.1.1.3 | INTEGER | read-only | Group Number. |
| STR oramodCfgLfSTATUS | 1.3.6.1.4.1.546.16.4.10.3.1.1.4 | DisplayString | read-only | Status of File. |
| STR oramodCfgLfMEMBER | 1.3.6.1.4.1.546.16.4.10.3.1.1.5 | DisplayString | read-only | File name and path. |
| oramodCfgSga | 1.3.6.1.4.1.546.16.4.10.4 | |||
| oramodCfgSgaTable | 1.3.6.1.4.1.546.16.4.10.4.1 | not-accessible | This table summarizes the system global area. | |
| oramodCfgSgaEntry | 1.3.6.1.4.1.546.16.4.10.4.1.1 | not-accessible | An entry in the Oracle Sga table. | |
| INT oramodCfgSgaSIDINDX | 1.3.6.1.4.1.546.16.4.10.4.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodCfgSgaTOTALMEMALLOC | 1.3.6.1.4.1.546.16.4.10.4.1.1.2 | INTEGER | read-only | Total real memory allocated. Summation of values in v$sga. |
| INT oramodCfgSgaFIXEDSGA | 1.3.6.1.4.1.546.16.4.10.4.1.1.3 | INTEGER | read-only | Fixed memory allocated in Kbytes |
| INT oramodCfgSgaVARIABLE | 1.3.6.1.4.1.546.16.4.10.4.1.1.4 | INTEGER | read-only | Variable Memory allocated in the SGA |
| INT oramodCfgSgaDBBUFF | 1.3.6.1.4.1.546.16.4.10.4.1.1.5 | INTEGER | read-only | Database buffers allocated in Kbytes. Typical Range is 4 Kbytes - 2 Gbytes. |
| INT oramodCfgSgaREDOBUFF | 1.3.6.1.4.1.546.16.4.10.4.1.1.6 | INTEGER | read-only | Redo Buffers allocated in Kbytes |
| oramodPerf | 1.3.6.1.4.1.546.16.4.11 | |||
| oramodFootprint | 1.3.6.1.4.1.546.16.4.11.1 | |||
| oramodFootprt | 1.3.6.1.4.1.546.16.4.11.1.1 | |||
| oramodFootprtTable | 1.3.6.1.4.1.546.16.4.11.1.1.1 | not-accessible | This table describes the system footprint. | |
| oramodFootprtEntry | 1.3.6.1.4.1.546.16.4.11.1.1.1.1 | not-accessible | An entry in the Oracle Footprint table. | |
| INT oramodFootprtSIDINDX | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.1 | INTEGER | read-only | Empire's Index Number. |
| INT oramodFootprtCPUTIME | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.2 | INTEGER | read-only | CPU time, in seconds, accumulated by Oracle which includes all its core components and instance. Because core components can come and go, the accumulated cpu time can fluctuate therefore making this variable unsuitable as a counter. |
| INT oramodFootprtPERCENTCPU | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.3 | INTEGER | read-only | The percentage of CPU utilization, by Oracle, over the last sample interval. Since fractions are not supported by SNMP, the value reported is the percentage multipled by 100. It is the sum of the CPU utilization of all the Oracle core services and components. Its gives a good indication of the CPU resource consumption by the entire Oracle application' |
| GAU oramodFootprtMEMSIZE | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.4 | Gauge | read-only | The combined size of Oracle's text, data, and stack segments in KBytes. It is the summation of the process sizes for all the core Oracle services and optional connectors. |
| GAU oramodFootprtRSS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.5 | Gauge | read-only | The real memory (resident set) size of Oracle in KBytes. It is the summation of the process RSS for all the core Oracle services and optional connectors. |
| INT oramodFootprtPERCENTMEM | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.6 | INTEGER | read-only | The percentage (0-100) of real memory used by the Oracle Application which includes core services and optional connectors. |
| GAU oramodFootprtTHREADS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.7 | Gauge | read-only | The total number of threads operating within the respective Oracle components as seen by the operating system. Monitoring the number of threads can help with performance tuning resource contention issues that may be brought about by too many threads or can help identify if too few threads have too great of a workload. |
| GAU oramodFootprtINBLKS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.8 | Gauge | read-only | The number of blocks of data input by the processes. |
| GAU oramodFootprtOUTBLKS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.9 | Gauge | read-only | The number of blocks of data put by the processes. |
| CTR oramodFootprtMSGSSENT | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.10 | Counter | read-only | The number of messages sent by the processes. |
| CTR oramodFootprtMSGSRCVD | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.11 | Counter | read-only | The number of messages received by the processes. |
| CTR oramodFootprtSYSCALLS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.12 | Counter | read-only | The number of system calls invoked by the processes. |
| CTR oramodFootprtMINORPGFLTS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.13 | Counter | read-only | The number of minor page faults incurred by the process. Minor faults do not require I/O to retrieve the page. |
| CTR oramodFootprtMAJORPGFLTS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.14 | Counter | read-only | The number of major page faults incurred by the process. Minor faults require I/O to retrieve the page. |
| CTR oramodFootprtNUMSWAPS | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.15 | Counter | read-only | The number of times the processes have been swapped. |
| CTR oramodFootprtVOLCNTX | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.16 | Counter | read-only | The number of voluntary context switches incurred by the processes. Voluntary contest switches occur when the processor voluntary gives up the CPU (e.g. waiting on I/O). |
| CTR oramodFootprtINVOLCNTX | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.17 | Counter | read-only | The number of involuntary context switches incurred by the processes. An involuntary context switch occurs when the process has executed for the duration of its time quantum and is switched out by the process scheduler. |
| GAU oramodFootprtHOMESIZE | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.18 | Gauge | read-only | The size, in KBytes of the Oracle root directory and all files beneath it. |
| GAU oramodFootprtDBDISKSIZE | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.19 | Gauge | read-only | The size, in KBytes, of all the Oracle Database disk storage areas. It is a summation of all database files. Summing these components in one location presents an easy and convenient MIB object to poll and self-monitor. |
| TIK oramodFootprtLASTUPDATE | 1.3.6.1.4.1.546.16.4.11.1.1.1.1.20 | TimeTicks | read-only | The time (based on sysUpTime) that the last update of all variables in the table was completed. |
| oramodFFootprt | 1.3.6.1.4.1.546.16.4.11.1.2 | |||
| oramodFFootprtTable | 1.3.6.1.4.1.546.16.4.11.1.2.1 | not-accessible | This table describes the system footprint. | |
| oramodFFootprtEntry | 1.3.6.1.4.1.546.16.4.11.1.2.1.1 | not-accessible | An entry in the Oracle File Footprint table. | |
| INT oramodFFootprtSIDINDX | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodFFootprtFILEINDX | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.2 | INTEGER | read-only | File Index Number. |
| STR oramodFFootprtFILETYPE | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.3 | DisplayString | read-only | File Type. |
| STR oramodFFootprtFILENAME | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.4 | DisplayString | read-only | File Name. |
| STR oramodFFootprtCRTTS | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.5 | DisplayString | read-only | Last update timestamp. |
| INT oramodFFootprtCRTKBYTES | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.6 | INTEGER | read-only | File creation kbytes. |
| INT oramodFFootprtKBYTES | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.7 | INTEGER | read-only | File kbytes. |
| INT oramodFFootprtBLOCKS | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.8 | INTEGER | read-only | File blocks. |
| STR oramodFFootprtSTATUS | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.9 | DisplayString | read-only | File Status. |
| STR oramodFFootprtRECOVER | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.10 | DisplayString | read-only | Last Recover timestamp. |
| STR oramodFFootprtAVGIOTIM | 1.3.6.1.4.1.546.16.4.11.1.2.1.1.11 | DisplayString | read-only | File average I/O time. |
| oramodMetrics | 1.3.6.1.4.1.546.16.4.11.2 | |||
| oramodMetricsTable | 1.3.6.1.4.1.546.16.4.11.2.1 | not-accessible | This table describes the database metrics. | |
| oramodMetricsEntry | 1.3.6.1.4.1.546.16.4.11.2.1.1 | not-accessible | An entry in the Metrics table. | |
| INT oramodMetricsSIDINDX | 1.3.6.1.4.1.546.16.4.11.2.1.1.1 | INTEGER | read-only | Sid Index Number. |
| GAU oramodMetricsBCPT | 1.3.6.1.4.1.546.16.4.11.2.1.1.2 | Gauge | read-only | Block Changes Per Transaction scaled by 100. This ratio measures the amount of DML work that each transaction performs. Creating or dropping indexes impact this value, because changes to index blocks increment it. |
| GAU oramodMetricsBGR | 1.3.6.1.4.1.546.16.4.11.2.1.1.3 | Gauge | read-only | Block Get Rate Per Second scaled by 100. This ratio determines the block get rate per second. It is a basic measurement of the rate at which the application systems reference the database. |
| GAU oramodMetricsBVPT | 1.3.6.1.4.1.546.16.4.11.2.1.1.4 | Gauge | read-only | Block Vists Per Transaction scaled by 100. This ratio measures the work database load imposed per transaction. It is a basic measurement of the application workload. If it is moving independently, then this strongly indicates that there has been a change in the application workload. |
| GAU oramodMetricsCHR | 1.3.6.1.4.1.546.16.4.11.2.1.1.5 | Gauge | read-only | Cache Hit Ratio scaled by 100. Measures the effectiveness of the hits against the buffer cache. Whenever Oracle reads data from disk, it places that data into the buffer cache. Data is aged out of the buffer cache using a least recently used algorithm. Oracle looks in the buffer cache first for data requests. If the data is not there, Oracle searches the disk based data files that comprise the database. On most production systems, Oracle should not have to resort to disk reads more than 20% of the time. So, if the buffer cache hit ratio is less than 80%, you should consider increasing the database buffer cache in the System Global Area. This can be done by increasing the value for DBBLOCKBUFFER in the initialization parameter file. |
| GAU oramodMetricsCR | 1.3.6.1.4.1.546.16.4.11.2.1.1.6 | Gauge | read-only | Call Rate over time. The number of user and recursive calls over time. This ratio measures the work demand rate being placed on the instance from all work sources. |
| GAU oramodMetricsCPT | 1.3.6.1.4.1.546.16.4.11.2.1.1.7 | Gauge | read-only | Calls Per Transaction scaled by 100. The number of database requests per committed transaction. Can be used to detect changes in the application, or in the way in which it is normally used. Ad hoc queries will cause this value to sharply increase. |
| GAU oramodMetricsCBR | 1.3.6.1.4.1.546.16.4.11.2.1.1.8 | Gauge | read-only | Changed Blocks scaled by 100. Measures the balance between queris and data manipulation language (DML) within the database applications. Can be used to detect changes in application usage or indexes. |
| GAU oramodMetricsCCR | 1.3.6.1.4.1.546.16.4.11.2.1.1.9 | Gauge | read-only | Consistent Change Ratio scaled by 100. The ratio of database consistent changes and consistent gets. It measures the extent to which applications are having to exercise the read consistency mechanism. Update and delete operations are subject to read consistency. |
| GAU oramodMetricsCRR | 1.3.6.1.4.1.546.16.4.11.2.1.1.10 | Gauge | read-only | Continued Row Ratio scaled by 100. Measures the space useage of data blocks. Should be close to zero, except in applications handling long LONG columns. If this ratio increases over time, usually PCTFREE has been set too low on one or more tables. |
| GAU oramodMetricsLCM | 1.3.6.1.4.1.546.16.4.11.2.1.1.11 | Gauge | read-only | Library Cache Miss Ratio scaled by 100. The ratio of missed requests and reloads to access library cached objects since instance startup. The library cache is a memory structure containing shared SQL and PL/SQL areas. Monitoring the library cache is important to determine whether or not to resize the shared pool. If this ratio increases over time, then resource useage can be expected to increase. A rising library cache miss ratio may be due to wider use of application functionality causing more SQL statements and stored procedures to be active that had been previously. |
| GAU oramodMetricsRTUC | 1.3.6.1.4.1.546.16.4.11.2.1.1.12 | Gauge | read-only | Recursive To User Call Ratio scaled by 100. The ratio of recursive and user or application calls. A change in this ratio can reflect an application change or the need to adjust the size of the shared pool. |
| GAU oramodMetricsRLSW | 1.3.6.1.4.1.546.16.4.11.2.1.1.13 | Gauge | read-only | Redo Log Space Wait Ratio scaled by 100. It shows the rate at which failures are occuring in writing to the redo log space and is used to measure memory allocation. If this ratio is greater than 1/5,000, the the redo log buffer should be increased until the redo log space wait ratio stops failing. |
| GAU oramodMetricsRSR | 1.3.6.1.4.1.546.16.4.11.2.1.1.14 | Gauge | read-only | Row Source Ratio scaled by 100. It shows the percentage of total rows retrieved which came from full table scans. If this percentage start to rise above zero, the interpretation of other statistics may need to be reviewed. |
| GAU oramodMetricsSOR | 1.3.6.1.4.1.546.16.4.11.2.1.1.15 | Gauge | read-only | Sort Overflow Ratio scaled by 100. Indicates the number of sorts which are using temporary segments. Under restrictive circumstances when there is a predominance of medium sorts, increasing the sort area size may be effective. |
| GAU oramodMetricsTRR | 1.3.6.1.4.1.546.16.4.11.2.1.1.16 | Gauge | read-only | Transaction Rate Ratio scaled by 100. The rate at which users or applications are committing transactions. If a fall in this value is associated with a rise in the number of connected users or vice versa, an administrator should be concerned. Changes in application structure or work patterns can also distort this figure. |
| GAU oramodMetricsUCR | 1.3.6.1.4.1.546.16.4.11.2.1.1.17 | Gauge | read-only | User Call Rate Ratio scaled by 100. The rate at which client users or applications are requesting sql statements. Measures the work demand rate being posed by client side applications running under the instance. May not be directly comparable across application system version changes where code has been moved from client to server or vice versa. |
| GAU oramodMetricsUCPP | 1.3.6.1.4.1.546.16.4.11.2.1.1.18 | Gauge | read-only | User Calls Per Parse Ratio scaled by 100. The ratio of user calls to parse in the shared SQL area. Indicates how well the application is managing its context area. If it changes, then application change is the most likely explanation, but it may indicate the useage patterns are changing and users are moving from one module to another either more frequently or less frequently. Although the shared SQL area makes the maximizing of this ratio less important than with earlier versions of Oracle, it is still possible to reduce resource usage by raising this ratio. |
| GAU oramodMetricsURR | 1.3.6.1.4.1.546.16.4.11.2.1.1.19 | Gauge | read-only | User Rollback Ratio scaled by 100. The ratio of user or application transaction rollbacks. Indicates the rate at which application transactions are failing. Rolling back a transaction uses significant resources, and would seem to indicate that all of the resources expended in executing the transaction have been wasted. |
| GAU oramodMetricsSGALCE | 1.3.6.1.4.1.546.16.4.11.2.1.1.20 | Gauge | read-only | Library Cache Efficiency Percentage scaled by 100. The percentage that a SQL statement did not need to be reloaded because it was already in the library cache. This percentage should be 100. If not, try resizing the SHAREDPOOLSIZE in the initialization file. |
| GAU oramodMetricsSGADDCE | 1.3.6.1.4.1.546.16.4.11.2.1.1.21 | Gauge | read-only | Data Dictionary Cache Efficiency Percentage scaled by 100. Shows the ratio of gets to misses within the shared pool. The ratio should be less than 0.1. Various database operations cause the RDBMS to access its system tables. These system tables are stored in the Oracle data dictionary. The objects in the data dictionary are stored in the system tablespace. When the RDBMS needs access to its system tables, the tables are read into the data dictionary cache. Resizing the shared pool can affect this ratio. |
| CTR oramodMetricsDBTOTALRW | 1.3.6.1.4.1.546.16.4.11.2.1.1.22 | Counter | read-only | The total number of physical reads and physical writes since instance startup. See individual descriptions below. |
| CTR oramodMetricsDBBLKCHG | 1.3.6.1.4.1.546.16.4.11.2.1.1.23 | Counter | read-only | The total number of database block changes. It is incremented each time that a database block is in memory to create a dirty block. This statistic is a rough indication of total database work. Increments at several thousand per second in the largest systems, so this variable is definitely a wraparound candidate. |
| CTR oramodMetricsDBBLKGET | 1.3.6.1.4.1.546.16.4.11.2.1.1.24 | Counter | read-only | The total number of database block gets since instance startup. It is incremented each time the buffer manager is asked for a database block in current mode, regardless of read consistency. This mode is used to locate blocks which are to be updated, and also to access control information such as segment headers. Only if the requested block is not found in Oracle's Buffer cache will a db block get result in physical I/O. |
| CTR oramodMetricsDBCNSTGET | 1.3.6.1.4.1.546.16.4.11.2.1.1.25 | Counter | read-only | The total number of consistent gets since instance startup. This value is incremented each time that the Oracle Buffer Manager is requested to locate a database block as part of a read consistent operation (a query). Only if the requested block is not found in Oracle's Buffer Cache will consistent get result in physical I/O. Increments at several thousand per second in the largest systems, so this variable is definitely a wraparound candidate. |
| CTR oramodMetricsDBPHYSREAD | 1.3.6.1.4.1.546.16.4.11.2.1.1.26 | Counter | read-only | The total number of physical reads since instance startup. It increments each time a DB Block is retrieved from the disk subsystem, but is not necessarily equal to the number of I/O requests made to the host operating system, as multiblock I/O may be used. A physical read can be viewed as an SGA Buffer Cache miss, hampering throughput (contention induction) and CPU (code pathlength) processing. Unlikely to increment at a rate greater than a few hundred per second. |
| CTR oramodMetricsDBSORTDISK | 1.3.6.1.4.1.546.16.4.11.2.1.1.27 | Counter | read-only | The total number of database disk sorts since instance startup. It increments for each sort which has to allocate disk work space. Should be zero. |
| CTR oramodMetricsDBSORTMEM | 1.3.6.1.4.1.546.16.4.11.2.1.1.28 | Counter | read-only | The total number of database memory sorts since instance startup. It is incremented for each sort which does not require the allocation of work. Unlikely to increment faster than tens per second, except in the largest systems. |
| GAU oramodMetricsBLKFREEWAIT | 1.3.6.1.4.1.546.16.4.11.2.1.1.29 | Gauge | read-only | The percent that a request resulted in a wait for a free block. Should be less than 1%. To reduce contention for a table's free list the table must be recreated with a larger value in the FREELISTS storage parameter. |
| GAU oramodMetricsMTHRDQUEUEWAIT | 1.3.6.1.4.1.546.16.4.11.2.1.1.30 | Gauge | read-only | The number of seconds waited in queue for multi-threaded servers. |
| CTR oramodMetricsSESSHIWTRMEM | 1.3.6.1.4.1.546.16.4.11.2.1.1.31 | Counter | read-only | The maximum highwater amount of session memory used. |
| CTR oramodMetricsSESSCURRMEM | 1.3.6.1.4.1.546.16.4.11.2.1.1.32 | Counter | read-only | The current maximum amount of session memory used. |
| CTR oramodMetricsSESSHIWTR | 1.3.6.1.4.1.546.16.4.11.2.1.1.33 | Counter | read-only | The highwater mark for number of sessions. |
| GAU oramodMetricsSESSCURRENT | 1.3.6.1.4.1.546.16.4.11.2.1.1.34 | Gauge | read-only | The current number of sessions. |
| CTR oramodMetricsUSERCOMMITS | 1.3.6.1.4.1.546.16.4.11.2.1.1.35 | Counter | read-only | Records the number of database transactions successfully completed and records the number of aborted database transactions. In most real world applications, the value is less the 1 per second. |
| CTR oramodMetricsUSERROLLBACK | 1.3.6.1.4.1.546.16.4.11.2.1.1.36 | Counter | read-only | The number of transactions rolled back since instance startup. |
| CTR oramodMetricsUSERCALLS | 1.3.6.1.4.1.546.16.4.11.2.1.1.37 | Counter | read-only | The number of transactions started since instance startup. |
| CTR oramodMetricsDBPHYSWRTS | 1.3.6.1.4.1.546.16.4.11.2.1.1.38 | Counter | read-only | The total number of physical writes since instance startup. It increments each time a DB Block is written to the disk. All writes are performed either by DBWR or LGWR, two background processes responsible for getting Blocks out of the SGA and back on disk. |
| CTR oramodMetricsTBLSCANROWS | 1.3.6.1.4.1.546.16.4.11.2.1.1.39 | Counter | read-only | The number of rows retrieved through table scans since instance startup. |
| CTR oramodMetricsTBLFTCHROWID | 1.3.6.1.4.1.546.16.4.11.2.1.1.40 | Counter | read-only | The number of rows retrieved through table fetches by rowid since instance startup. |
| CTR oramodMetricsTBLFTCHCROW | 1.3.6.1.4.1.546.16.4.11.2.1.1.41 | Counter | read-only | The number of rows retrieved through table fetches by continued row since instance startup. |
| CTR oramodMetricsRECRSVCALLS | 1.3.6.1.4.1.546.16.4.11.2.1.1.42 | Counter | read-only | The number of recursive calls since instance startup. |
| CTR oramodMetricsCNSTCHGS | 1.3.6.1.4.1.546.16.4.11.2.1.1.43 | Counter | read-only | The number of consistent changes since instance startup. |
| CTR oramodMetricsPARSECNT | 1.3.6.1.4.1.546.16.4.11.2.1.1.44 | Counter | read-only | The number of parses since instance startup. |
| INT oramodMetricsCPUTM | 1.3.6.1.4.1.546.16.4.11.2.1.1.45 | INTEGER | read-only | The amount of time taken to work requests. |
| INT oramodMetricsLOGFILESWTCH | 1.3.6.1.4.1.546.16.4.11.2.1.1.46 | INTEGER | read-only | The number of redo log file switches. |
| STR oramodMetricsARCHIVER | 1.3.6.1.4.1.546.16.4.11.2.1.1.47 | DisplayString | read-only | The database archiver. |
| STR oramodMetricsDATABASESTATUS | 1.3.6.1.4.1.546.16.4.11.2.1.1.48 | DisplayString | read-only | The status of the database. |
| STR oramodMetricsSHUTDOWNPENDING | 1.3.6.1.4.1.546.16.4.11.2.1.1.49 | DisplayString | read-only | The shutdown status of the database. |
| TIK oramodMetricsLASTUPDATE | 1.3.6.1.4.1.546.16.4.11.2.1.1.50 | TimeTicks | read-only | The time (based on sysUpTime) that the last update of all variables in the table was completed. |
| oramodSGA | 1.3.6.1.4.1.546.16.4.11.3 | |||
| oramodSgaDddAgg | 1.3.6.1.4.1.546.16.4.11.3.1 | |||
| oramodSgaDddAggTable | 1.3.6.1.4.1.546.16.4.11.3.1.1 | not-accessible | This table describes the data dictionary aggregates. | |
| oramodSgaDddAggEntry | 1.3.6.1.4.1.546.16.4.11.3.1.1.1 | not-accessible | An entry in the Data Dictionary Aggregate table. | |
| INT oramodSGAAGGSIDINDX | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.1 | INTEGER | read-only | Sid Index Number. |
| CTR oramodSGAAGGCNT | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.2 | Counter | read-only | Total number of entries in the data dictionary cache since instance startup. |
| CTR oramodSGAAGGUSGE | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.3 | Counter | read-only | The total number of cache entries with valid data since instance startup. |
| CTR oramodSGAAGGFIX | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.4 | Counter | read-only | The total number of fixed entries in the data dictionary cache since instance startup. |
| CTR oramodSGAAGGGET | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.5 | Counter | read-only | The total number of information requests since instance startup. |
| CTR oramodSGAAGGGETMISS | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.6 | Counter | read-only | The total number of informations requests resulting in cache misses since instance startup. |
| CTR oramodSGAAGGSCAN | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.7 | Counter | read-only | The total number of scan requests since instance startup. |
| CTR oramodSGAAGGSCANMISS | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.8 | Counter | read-only | The total number of scan requests resulting in misses since instance startup. |
| CTR oramodSGAAGGSCANCPLT | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.9 | Counter | read-only | For subordinate entries, the total number of times list was scanned completely since instance startup. |
| CTR oramodSGAAGGMODS | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.10 | Counter | read-only | The total number of inserts, updates, and deletions since instance startup. |
| CTR oramodSGAAGGFLUSH | 1.3.6.1.4.1.546.16.4.11.3.1.1.1.11 | Counter | read-only | The total number of times flushed to disk since instance startup. |
| oramodSgaDlci | 1.3.6.1.4.1.546.16.4.11.3.2 | |||
| oramodSgaDlciTable | 1.3.6.1.4.1.546.16.4.11.3.2.1 | not-accessible | This table describes the detailed library cache information. | |
| oramodSgaDlciEntry | 1.3.6.1.4.1.546.16.4.11.3.2.1.1 | not-accessible | An entry in the Library Cache table. | |
| INT oramodSGADLCISIDINDX | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodSGADLCIINDX | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.2 | INTEGER | read-only | Namespace Index Number. |
| STR oramodSGADLCINAME | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.3 | DisplayString | read-only | Library Cache Namespace. (SQL AREA, TABLE/PROCEDURE, BODY, TRIGGER, INDEX, CLUSTER, OBJECT, PIPE) |
| CTR oramodSGADLCIGET | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.4 | Counter | read-only | The total number of request handles to library namespace since instance startup Typical range (0..500,00). |
| CTR oramodSGADLCIGETHIT | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.5 | Counter | read-only | The total number of times handles are already allocated in the cache. If the handle is not already allocated it is a miss. |
| GAU oramodSGADLCIGETHITRT | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.6 | Gauge | read-only | The Get/Hit ratio determines the percentage of parse calls that find a cursor to share. The value is derived from GETHITS divided by GETS. Should be in the high 90s which indicates that most of the handles the system has tried to get are cached. |
| CTR oramodSGADLCIPIN | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.7 | Counter | read-only | The total number of pin requests for objects in the cache since instance startup. |
| CTR oramodSGADLCIPINHIT | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.8 | Counter | read-only | The number of pin hits or executions of objects that are already allocated and initiated in the cache. Otherwise, it is a miss, and the system has to reallocate and initialize it with data queried from the database or generate the data. |
| GAU oramodSGADLCIPINHITRT | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.9 | Gauge | read-only | The ratio of PINHITS to PINS. Values close to 100 indicate that most of the objects the system has tried to pin and access have been cached. |
| CTR oramodSGADLCIRELOAD | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.10 | Counter | read-only | Number of times a statement had to be reparsed in order to be executed. Statements are reloaded due to aging or invalidation. Should never be more that one percent of PINS. Goal is the have close to zero reloads. |
| CTR oramodSGADLCIINVALID | 1.3.6.1.4.1.546.16.4.11.3.2.1.1.11 | Counter | read-only | The number of times that non-persistant library objects (like SQL areas) have been invalidated. |
| oramodRedoLogBuf | 1.3.6.1.4.1.546.16.4.11.4 | |||
| oramodRedoLogBufTable | 1.3.6.1.4.1.546.16.4.11.4.1 | not-accessible | This table describes the Redo Log information. | |
| oramodRedoLogBufEntry | 1.3.6.1.4.1.546.16.4.11.4.1.1 | not-accessible | An entry in the Redo Log table. | |
| INT oramodREDOSIDINDX | 1.3.6.1.4.1.546.16.4.11.4.1.1.1 | INTEGER | read-only | Sid Index Number. |
| CTR oramodREDOBLKWRT | 1.3.6.1.4.1.546.16.4.11.4.1.1.2 | Counter | read-only | The total number of redo blocks written since instance startup. |
| CTR oramodREDOENTRIES | 1.3.6.1.4.1.546.16.4.11.4.1.1.3 | Counter | read-only | The total number of redo entries in the redo log since instance startup. |
| INT oramodREDOSIZE | 1.3.6.1.4.1.546.16.4.11.4.1.1.4 | INTEGER | read-only | The size of the redo log. |
| CTR oramodREDOSPACERQST | 1.3.6.1.4.1.546.16.4.11.4.1.1.5 | Counter | read-only | The number of redo log space requests. Should be close to zero. A nonzero value means the the buffer may be too small. Increase the size of the buffer so that processes are not waiting. The INIT.ora parameter LOGBUFFER controls the size of the redo log buffer. |
| CTR oramodREDOSPACEWAIT | 1.3.6.1.4.1.546.16.4.11.4.1.1.6 | Counter | read-only | The total number of redo log space wait time since instance startup |
| CTR oramodREDOSYNCHWRT | 1.3.6.1.4.1.546.16.4.11.4.1.1.7 | Counter | read-only | The total number of redo synch writes since instance startup. |
| INT oramodREDOSYNCHTM | 1.3.6.1.4.1.546.16.4.11.4.1.1.8 | INTEGER | read-only | The amount of redo log synch time. |
| CTR oramodREDOWASTAGE | 1.3.6.1.4.1.546.16.4.11.4.1.1.9 | Counter | read-only | The total amount of redo log wastage. |
| CTR oramodREDORETRIES | 1.3.6.1.4.1.546.16.4.11.4.1.1.10 | Counter | read-only | The total number of redo retries. |
| TIK oramodREDOLASTUPDATE | 1.3.6.1.4.1.546.16.4.11.4.1.1.11 | TimeTicks | read-only | The time (based on sysUpTime) that the last update of all variables in the table was completed. |
| oramodRollBack | 1.3.6.1.4.1.546.16.4.11.5 | |||
| oramodRollBackTable | 1.3.6.1.4.1.546.16.4.11.5.1 | not-accessible | This table describes any rollback segments. | |
| oramodRollBackEntry | 1.3.6.1.4.1.546.16.4.11.5.1.1 | not-accessible | An entry in the rollstat table. | |
| INT oramodRollBackSIDINDX | 1.3.6.1.4.1.546.16.4.11.5.1.1.1 | INTEGER | read-only | SID Index Number. |
| INT oramodRollBackSEGINDX | 1.3.6.1.4.1.546.16.4.11.5.1.1.2 | INTEGER | read-only | Undo Segment Number used as an index. |
| STR oramodRollBackSEGNAME | 1.3.6.1.4.1.546.16.4.11.5.1.1.3 | DisplayString | read-only | Rollback Segment Name. |
| CTR oramodRollBackEXTENTS | 1.3.6.1.4.1.546.16.4.11.5.1.1.4 | Counter | read-only | The total number of Segment Extends since instance startup. |
| CTR oramodRollBackRSSIZE | 1.3.6.1.4.1.546.16.4.11.5.1.1.5 | Counter | read-only | The size of the Rollback Segment. |
| CTR oramodRollBackWRITES | 1.3.6.1.4.1.546.16.4.11.5.1.1.6 | Counter | read-only | The total number of Segment Writes since instance startup. |
| CTR oramodRollBackGETS | 1.3.6.1.4.1.546.16.4.11.5.1.1.7 | Counter | read-only | The total number of Rollback Segment Gets since instance startup. |
| CTR oramodRollBackWAITS | 1.3.6.1.4.1.546.16.4.11.5.1.1.8 | Counter | read-only | The total number of Segment Waits since instance startup. |
| INT oramodRollBackOPTSIZE | 1.3.6.1.4.1.546.16.4.11.5.1.1.9 | INTEGER | read-only | The Optimal Size of the Rollback Segment. This size should be set based on application usage to minimize space management issues. |
| CTR oramodRollBackSHRINKS | 1.3.6.1.4.1.546.16.4.11.5.1.1.10 | Counter | read-only | The total number of Rollback Segment Shrinks since instance startup. Rollback Segments shrink back to their optimal size after extends have occurred. |
| CTR oramodRollBackWRAPS | 1.3.6.1.4.1.546.16.4.11.5.1.1.11 | Counter | read-only | The total number of Rollback Segment wraps since instance startup. When a transaction's rollback segment entry cannot be stored within a single extent, the entry wraps into a second extent within the rollback segment. If this value is non-zero, try recreating the rollback segments with larger extent sizes. |
| CTR oramodRollBackEXTENDS | 1.3.6.1.4.1.546.16.4.11.5.1.1.12 | Counter | read-only | Rollback Segment extends. Extensions indicate that the rollback segments are handling larger transactions than they were designed for; and if the entire rollback segment cannot handle a transaction's rollback information, a single extent will not be able to hold it either. Thus, rollback segments that extend will frequently have a high number of wraps. |
| INT oramodRollBackAVESHRINK | 1.3.6.1.4.1.546.16.4.11.5.1.1.13 | INTEGER | read-only | The average shrink size of the Rollback Segment since this instance startup. |
| CTR oramodRollBackAVEACTIVE | 1.3.6.1.4.1.546.16.4.11.5.1.1.14 | Counter | read-only | Segment average active. |
| INT oramodRollBackSTATUS | 1.3.6.1.4.1.546.16.4.11.5.1.1.15 | INTEGER | read-only | Segment status. |
| oramodWaits | 1.3.6.1.4.1.546.16.4.11.6 | |||
| oramodWaitsTable | 1.3.6.1.4.1.546.16.4.11.6.1 | not-accessible | This table describes resource waits. | |
| oramodWaitsEntry | 1.3.6.1.4.1.546.16.4.11.6.1.1 | not-accessible | An entry in the waits table. | |
| INT oramodWaitsSIDINDX | 1.3.6.1.4.1.546.16.4.11.6.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodWaitsEVENTINDX | 1.3.6.1.4.1.546.16.4.11.6.1.1.2 | INTEGER | read-only | Event's Index Number. |
| STR oramodWaitsEVENT | 1.3.6.1.4.1.546.16.4.11.6.1.1.3 | DisplayString | read-only | Resource Name. |
| CTR oramodWaitsTOTALWAITS | 1.3.6.1.4.1.546.16.4.11.6.1.1.4 | Counter | read-only | Resource Total Waits. |
| CTR oramodWaitsTOTALTIMOUT | 1.3.6.1.4.1.546.16.4.11.6.1.1.5 | Counter | read-only | Resource Total Timeouts. |
| CTR oramodWaitsTIMEWAITED | 1.3.6.1.4.1.546.16.4.11.6.1.1.6 | Counter | read-only | Resource Total Waited. |
| CTR oramodWaitsAVGWAIT | 1.3.6.1.4.1.546.16.4.11.6.1.1.7 | Counter | read-only | Resource average wait. |
| oramodExpSql | 1.3.6.1.4.1.546.16.4.11.7 | |||
| oramodExpSqlTable | 1.3.6.1.4.1.546.16.4.11.7.1 | not-accessible | This table describes expensive sql. | |
| oramodExpSqlEntry | 1.3.6.1.4.1.546.16.4.11.7.1.1 | not-accessible | An entry in the v$sqlarea table. | |
| INT oramodExpSqlSIDINDX | 1.3.6.1.4.1.546.16.4.11.7.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodExpSqlSQLINDX | 1.3.6.1.4.1.546.16.4.11.7.1.1.2 | INTEGER | read-only | SQL Statement Index Number. |
| GAU oramodExpSqlEXECUTION | 1.3.6.1.4.1.546.16.4.11.7.1.1.3 | Gauge | read-only | Number of Executions. |
| GAU oramodExpSqlDISKREAD | 1.3.6.1.4.1.546.16.4.11.7.1.1.4 | Gauge | read-only | Number of Disk Reads. |
| GAU oramodExpSqlPARSECNT | 1.3.6.1.4.1.546.16.4.11.7.1.1.5 | Gauge | read-only | Number of Parses. Parsing is the work done by the database to validate the SQL statement and generate the query plan used for execution. When the parse count is close to that of executions for a given statement, you may be continually reparsing that statement. You can reduce parsing by making sure that statements are reused as much as possible in the shared pool. In general, a large number of hard parses indicates that more memory is needed for the shared pool. |
| GAU oramodExpSqlBUFFGETS | 1.3.6.1.4.1.546.16.4.11.7.1.1.6 | Gauge | read-only | Number of Buffer Gets. |
| GAU oramodExpSqlSORTS | 1.3.6.1.4.1.546.16.4.11.7.1.1.7 | Gauge | read-only | Number of Sorts. |
| STR oramodExpSqlSQL | 1.3.6.1.4.1.546.16.4.11.7.1.1.8 | DisplayString | read-only | Sql Statement truncated. |
| oramodTblsp | 1.3.6.1.4.1.546.16.4.11.8 | |||
| oramodTblspTable | 1.3.6.1.4.1.546.16.4.11.8.1 | not-accessible | List Fragmentation Information. | |
| oramodTblspEntry | 1.3.6.1.4.1.546.16.4.11.8.1.1 | not-accessible | An entry from the dbafreespace table. | |
| INT oramodTblspSIDINDX | 1.3.6.1.4.1.546.16.4.11.8.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodTblspTBLSPINDX | 1.3.6.1.4.1.546.16.4.11.8.1.1.2 | INTEGER | read-only | Tablespace Index Number. |
| STR oramodTblspTBLSPNAME | 1.3.6.1.4.1.546.16.4.11.8.1.1.3 | DisplayString | read-only | Tablespace Name. |
| STR oramodTblspFILENAME | 1.3.6.1.4.1.546.16.4.11.8.1.1.4 | DisplayString | read-only | File Name. |
| GAU oramodTblspEXTENTS | 1.3.6.1.4.1.546.16.4.11.8.1.1.5 | Gauge | read-only | The number of extents. |
| GAU oramodTblspLRGEXTENT | 1.3.6.1.4.1.546.16.4.11.8.1.1.6 | Gauge | read-only | Size in bytes of the largest extent. |
| GAU oramodTblspSMEXTENT | 1.3.6.1.4.1.546.16.4.11.8.1.1.7 | Gauge | read-only | Size in bytes of the smallest extent. |
| INT oramodTblspINCREMENTBY | 1.3.6.1.4.1.546.16.4.11.8.1.1.8 | INTEGER | read-only | Size in bytes of the next extent increment. |
| GAU oramodTblspBYTESCOALSD | 1.3.6.1.4.1.546.16.4.11.8.1.1.9 | Gauge | read-only | The number of free bytes that were coalesed. If this number does not match bytesfree then the tablespace has some extents that can be coalesced. |
| GAU oramodTblspBYTESFREE | 1.3.6.1.4.1.546.16.4.11.8.1.1.10 | Gauge | read-only | The total number of free bytes available. |
| oramodLocks | 1.3.6.1.4.1.546.16.4.11.9 | |||
| oramodLock | 1.3.6.1.4.1.546.16.4.11.9.1 | |||
| oramodLockTable | 1.3.6.1.4.1.546.16.4.11.9.1.1 | not-accessible | Lock Holders and Requestors | |
| oramodLockEntry | 1.3.6.1.4.1.546.16.4.11.9.1.1.1 | not-accessible | An entry from the lock and session tables. | |
| INT oramodLockSIDINDX | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodLockUSERINDX | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.2 | INTEGER | read-only | User's Index Number. |
| STR oramodLockUSERNAME | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.3 | DisplayString | read-only | User Name holding the lock. |
| STR oramodLockOBJECT | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.4 | DisplayString | read-only | The name of the locked object. |
| STR oramodLockTYPE | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.5 | DisplayString | read-only | Object Type. |
| INT oramodLockMODE | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.6 | INTEGER | read-only | Lock Mode held (Null, Row share, Row exclusive, Share, Share row exclusive, Exclusive). |
| INT oramodLockCTIME | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.7 | INTEGER | read-only | Time since current mode was granted. |
| INT oramodLockBLOCK | 1.3.6.1.4.1.546.16.4.11.9.1.1.1.8 | INTEGER | read-only | The lock is blocking another lock. |
| oramodLatch | 1.3.6.1.4.1.546.16.4.11.9.2 | |||
| oramodLatchTable | 1.3.6.1.4.1.546.16.4.11.9.2.1 | not-accessible | Latch information. | |
| oramodLatchEntry | 1.3.6.1.4.1.546.16.4.11.9.2.1.1 | not-accessible | An entry from the latch table. | |
| INT oramodLatchSIDINDX | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodLatchLATCHINDX | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.2 | INTEGER | read-only | Latch Index Number. |
| INT oramodLatchLATCHNUM | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.3 | INTEGER | read-only | Latch Number. |
| STR oramodLatchLATCHNAME | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.4 | DisplayString | read-only | Latch Name. |
| CTR oramodLatchGETS | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.5 | Counter | read-only | Latch Gets. Reflects the proportion of times requests for latches are satisfied without waiting. Should be high. |
| CTR oramodLatchMISSES | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.6 | Counter | read-only | Latch Misses. |
| CTR oramodLatchSLEEPS | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.7 | Counter | read-only | Latch Sleeps. |
| CTR oramodLatchIMDGETS | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.8 | Counter | read-only | Latch Immediate Gets. |
| CTR oramodLatchIMDMISSES | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.9 | Counter | read-only | Latch Immediate Misses. |
| CTR oramodLatchWAITSHOLDING | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.10 | Counter | read-only | Latch Immediate Misses. When a session cannot acquire a latch, it goes into active wait and repeatedly trys to acquire the latch impaitiently. |
| CTR oramodLatchSPINGETS | 1.3.6.1.4.1.546.16.4.11.9.2.1.1.11 | Counter | read-only | Latch Spin Gets. Some latch types will lock into a tight loop testing the latch and trying to get it. Spinning uses significant CPU resources. The number of spins depends on the spincount set it the init.ora file. Once the number of spincounts has been reached the prcess will back off and sleep. |
| oramodBackups | 1.3.6.1.4.1.546.16.4.11.10 | |||
| oramodBackup | 1.3.6.1.4.1.546.16.4.11.10.1 | |||
| oramodBackupTable | 1.3.6.1.4.1.546.16.4.11.10.1.1 | not-accessible | Backup Information | |
| oramodBackupEntry | 1.3.6.1.4.1.546.16.4.11.10.1.1.1 | not-accessible | An entry from the backup table. | |
| INT oramodBackupSIDINDX | 1.3.6.1.4.1.546.16.4.11.10.1.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodBackupFILENUM | 1.3.6.1.4.1.546.16.4.11.10.1.1.1.2 | INTEGER | read-only | Backup File Index Number. |
| STR oramodBackupSTATUS | 1.3.6.1.4.1.546.16.4.11.10.1.1.1.3 | DisplayString | read-only | Status of the backup. |
| INT oramodBackupCHANGENUM | 1.3.6.1.4.1.546.16.4.11.10.1.1.1.4 | INTEGER | read-only | The change number of the backup file. |
| STR oramodBackupDATE | 1.3.6.1.4.1.546.16.4.11.10.1.1.1.5 | DisplayString | read-only | Date of the Backup. |
| oramodArchive | 1.3.6.1.4.1.546.16.4.11.11 | |||
| oramodArcDest | 1.3.6.1.4.1.546.16.4.11.11.1 | |||
| oramodArcDestTable | 1.3.6.1.4.1.546.16.4.11.11.1.1 | not-accessible | Archive Information. | |
| oramodArcDestEntry | 1.3.6.1.4.1.546.16.4.11.11.1.1.1 | not-accessible | An entry from the archive destination table. | |
| INT oramodArcDestSIDINDX | 1.3.6.1.4.1.546.16.4.11.11.1.1.1.1 | INTEGER | read-only | Sid Index Number. |
| INT oramodArcDestARCINDX | 1.3.6.1.4.1.546.16.4.11.11.1.1.1.2 | INTEGER | read-only | Index of Archive log. |
| STR oramodArcDestARCMODE | 1.3.6.1.4.1.546.16.4.11.11.1.1.1.3 | DisplayString | read-only | Mode of Archive log. |
| STR oramodArcDestSTATUS | 1.3.6.1.4.1.546.16.4.11.11.1.1.1.4 | DisplayString | read-only | Status of Archive Log File. |
| STR oramodArcDestDEST | 1.3.6.1.4.1.546.16.4.11.11.1.1.1.5 | DisplayString | read-only | Archive Log File Destination. |
| oramodTtlFootprt | 1.3.6.1.4.1.546.16.4.12 | |||
| INT oramodTtlCPUTIME | 1.3.6.1.4.1.546.16.4.12.1 | INTEGER | read-only | CPU time, in seconds, accumulated by Oracle which includes all its core components and instance. Because core components can come and go, the accumulated cpu time can fluctuate therefore making this variable unsuitable as a counter. |
| INT oramodTtlPERCENTCPU | 1.3.6.1.4.1.546.16.4.12.2 | INTEGER | read-only | The percentage of CPU utilization, by Oracle, over the last sample interval. Since fractions are not supported by SNMP, the value reported is the percentage multipled by 100. It is the sum of the CPU utilization of all the Oracle core services and components. Its gives a good indication of the CPU resource consumption by the entire Oracle application' |
| GAU oramodTtlMEMSIZE | 1.3.6.1.4.1.546.16.4.12.3 | Gauge | read-only | The combined size of Oracle's text, data, and stack segments in KBytes. It is the summation of the process sizes for all the core Oracle services and optional connectors. |
| GAU oramodTtlRSS | 1.3.6.1.4.1.546.16.4.12.4 | Gauge | read-only | The real memory (resident set) size of Oracle in KBytes. It is the summation of the process RSS for all the core Oracle services and optional connectors. |
| INT oramodTtlPERCENTMEM | 1.3.6.1.4.1.546.16.4.12.5 | INTEGER | read-only | The percentage (0-100) of real memory used by the Oracle Application which includes core services and optional connectors. |
| GAU oramodTtlTHREADS | 1.3.6.1.4.1.546.16.4.12.6 | Gauge | read-only | The total number of threads operating within the respective Oracle components as seen by the operating system. Monitoring the number of threads can help with performance tuning resource contention issues that may be brought about by too many threads or can help identify if too few threads have too great of a workload. |
| GAU oramodTtlINBLKS | 1.3.6.1.4.1.546.16.4.12.7 | Gauge | read-only | The number of blocks of data input by the processes. |
| GAU oramodTtlOUTBLKS | 1.3.6.1.4.1.546.16.4.12.8 | Gauge | read-only | The number of blocks of data put by the processes. |
| CTR oramodTtlMSGSSENT | 1.3.6.1.4.1.546.16.4.12.9 | Counter | read-only | The number of messages sent by the processes. |
| CTR oramodTtlMSGSRCVD | 1.3.6.1.4.1.546.16.4.12.10 | Counter | read-only | The number of messages received by the processes. |
| CTR oramodTtlSYSCALLS | 1.3.6.1.4.1.546.16.4.12.11 | Counter | read-only | The number of system calls invoked by the processes. |
| CTR oramodTtlMINORPGFLTS | 1.3.6.1.4.1.546.16.4.12.12 | Counter | read-only | The number of minor page faults incurred by the process. Minor faults do not require I/O to retrieve the page. |
| CTR oramodTtlMAJORPGFLTS | 1.3.6.1.4.1.546.16.4.12.13 | Counter | read-only | The number of major page faults incurred by the process. Minor faults require I/O to retrieve the page. |
| CTR oramodTtlNUMSWAPS | 1.3.6.1.4.1.546.16.4.12.14 | Counter | read-only | The number of times the processes have been swapped. |
| CTR oramodTtlVOLCNTX | 1.3.6.1.4.1.546.16.4.12.15 | Counter | read-only | The number of voluntary context switches incurred by the processes. Voluntary contest switches occur when the processor voluntary gives up the CPU (e.g. waiting on I/O). |
| CTR oramodTtlINVOLCNTX | 1.3.6.1.4.1.546.16.4.12.16 | Counter | read-only | The number of involuntary context switches incurred by the processes. An involuntary context switch occurs when the process has executed for the duration of its time quantum and is switched out by the process scheduler. |
| INT oramodTtlDISKSIZE | 1.3.6.1.4.1.546.16.4.12.17 | INTEGER | read-only | The size, in KBytes of the Oracle root directory and all the Database Disk storage areas. |
RFC description
Monitors Oracle database performance, configuration, and resource utilization.
Start monitoring Server running Oracle database, monitored by CA/Empire SystemEDGE agent with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.