EMPIRE-ORAMOD

File: EMPIRE-ORAMOD.mib (120477 bytes)

Imported modules

RFC-1212 RFC-1215 RFC1213-MIB
RFC1155-SMI

Imported symbols

OBJECT-TYPE TRAP-TYPE DisplayString
enterprises TimeTicks Counter
Gauge

Defined Types

OramodDbCfgEntry  
SEQUENCE    
  oramodDbCfgSIDINDX INTEGER
  oramodDbCfgSID DisplayString
  oramodDbCfgVERSION DisplayString
  oramodDbCfgHOME DisplayString
  oramodDbCfgBASE DisplayString
  oramodDbCfgID INTEGER
  oramodDbCfgCRTDT DisplayString
  oramodDbCfgLOGMODE DisplayString
  oramodDbCfgCTRLFILETYPE DisplayString
  oramodDbCfgOPENMODE DisplayString
  oramodDbCfgMAXPROCESS INTEGER
  oramodDbCfgMAXSESSION INTEGER
  oramodDbCfgTIMEDSTATISTICS DisplayString
  oramodDbCfgCPUCNT INTEGER
  oramodDbCfgSHAREDPOOLSIZE INTEGER
  oramodDbCfgSHAREDPOOLRSSIZE INTEGER
  oramodDbCfgLARGEPOOLSIZE INTEGER
  oramodDbCfgJAVAPOOLSIZE INTEGER
  oramodDbCfgCNTRLFILES DisplayString
  oramodDbCfgDBBLKBUFF INTEGER
  oramodDbCfgDBBLKSIZE INTEGER
  oramodDbCfgCKPTINTRVL INTEGER
  oramodDbCfgDBFILES INTEGER
  oramodDbCfgSORTAREASIZE INTEGER
  oramodDbCfgOPENCURSORS INTEGER
  oramodDbCfgTRNSACTNS INTEGER
  oramodDbCfgTRNSACTNSPERSEG INTEGER
  oramodDbCfgMAXROLLSEG INTEGER

OramodCfgDfEntry  
SEQUENCE    
  oramodCfgDfSIDINDX INTEGER
  oramodCfgDfFILENUM INTEGER
  oramodCfgDfSTATUS DisplayString
  oramodCfgDfENABLED DisplayString
  oramodCfgDfUNRCVRBLECHG INTEGER
  oramodCfgDfUNRCVRBLETIME INTEGER
  oramodCfgDfKBYTES INTEGER
  oramodCfgDfCRTKBYTES INTEGER
  oramodCfgDfFNAME DisplayString
  oramodCfgDfCRTTIME DisplayString
  oramodCfgDfTBLESPACENUM INTEGER
  oramodCfgDfTBLESPACERFILENUM INTEGER
  oramodCfgDfBLOCKS INTEGER
  oramodCfgDfBLOCKSIZE INTEGER
  oramodCfgDfERROR INTEGER
  oramodCfgDfRECOVER DisplayString
  oramodCfgDfRSTLOGSCHGNUM INTEGER
  oramodCfgDfRSTLOGSTIME DisplayString

OramodCfgLfEntry  
SEQUENCE    
  oramodCfgLfSIDINDX INTEGER
  oramodCfgLfMEMBERINDX INTEGER
  oramodCfgLfGROUPNUM INTEGER
  oramodCfgLfSTATUS DisplayString
  oramodCfgLfMEMBER DisplayString

OramodCfgSgaEntry  
SEQUENCE    
  oramodCfgSgaSIDINDX INTEGER
  oramodCfgSgaTOTALMEMALLOC INTEGER
  oramodCfgSgaFIXEDSGA INTEGER
  oramodCfgSgaVARIABLE INTEGER
  oramodCfgSgaDBBUFF INTEGER
  oramodCfgSgaREDOBUFF INTEGER

OramodFootprtEntry  
SEQUENCE    
  oramodFootprtSIDINDX INTEGER
  oramodFootprtCPUTIME INTEGER
  oramodFootprtPERCENTCPU INTEGER
  oramodFootprtMEMSIZE Gauge
  oramodFootprtRSS Gauge
  oramodFootprtPERCENTMEM INTEGER
  oramodFootprtTHREADS Gauge
  oramodFootprtINBLKS Gauge
  oramodFootprtOUTBLKS Gauge
  oramodFootprtMSGSSENT Counter
  oramodFootprtMSGSRCVD Counter
  oramodFootprtSYSCALLS Counter
  oramodFootprtMINORPGFLTS Counter
  oramodFootprtMAJORPGFLTS Counter
  oramodFootprtNUMSWAPS Counter
  oramodFootprtVOLCNTX Counter
  oramodFootprtINVOLCNTX Counter
  oramodFootprtHOMESIZE Gauge
  oramodFootprtDBDISKSIZE Gauge
  oramodFootprtLASTUPDATE TimeTicks

OramodFFootprtEntry  
SEQUENCE    
  oramodFFootprtSIDINDX INTEGER
  oramodFFootprtFILEINDX INTEGER
  oramodFFootprtFILETYPE DisplayString
  oramodFFootprtFILENAME DisplayString
  oramodFFootprtCRTTS DisplayString
  oramodFFootprtCRTKBYTES INTEGER
  oramodFFootprtKBYTES INTEGER
  oramodFFootprtBLOCKS INTEGER
  oramodFFootprtSTATUS DisplayString
  oramodFFootprtRECOVER DisplayString
  oramodFFootprtAVGIOTIM DisplayString

OramodMetricsEntry  
SEQUENCE    
  oramodMetricsSIDINDX INTEGER
  oramodMetricsBCPT Gauge
  oramodMetricsBGR Gauge
  oramodMetricsBVPT Gauge
  oramodMetricsCHR Gauge
  oramodMetricsCR Gauge
  oramodMetricsCPT Gauge
  oramodMetricsCBR Gauge
  oramodMetricsCCR Gauge
  oramodMetricsCRR Gauge
  oramodMetricsLCM Gauge
  oramodMetricsRTUC Gauge
  oramodMetricsRLSW Gauge
  oramodMetricsRSR Gauge
  oramodMetricsSOR Gauge
  oramodMetricsTRR Gauge
  oramodMetricsUCR Gauge
  oramodMetricsUCPP Gauge
  oramodMetricsURR Gauge
  oramodMetricsSGALCE Gauge
  oramodMetricsSGADDCE Gauge
  oramodMetricsDBTOTALRW Counter
  oramodMetricsDBBLKCHG Counter
  oramodMetricsDBBLKGET Counter
  oramodMetricsDBCNSTGET Counter
  oramodMetricsDBPHYSREAD Counter
  oramodMetricsDBSORTDISK Counter
  oramodMetricsDBSORTMEM Counter
  oramodMetricsBLKFREEWAIT Gauge
  oramodMetricsMTHRDQUEUEWAIT Gauge
  oramodMetricsSESSHIWTRMEM Counter
  oramodMetricsSESSCURRMEM Counter
  oramodMetricsSESSHIWTR Counter
  oramodMetricsSESSCURRENT Gauge
  oramodMetricsUSERCOMMITS Counter
  oramodMetricsUSERROLLBACK Counter
  oramodMetricsUSERCALLS Counter
  oramodMetricsDBPHYSWRTS Counter
  oramodMetricsTBLSCANROWS Counter
  oramodMetricsTBLFTCHROWID Counter
  oramodMetricsTBLFTCHCROW Counter
  oramodMetricsRECRSVCALLS Counter
  oramodMetricsCNSTCHGS Counter
  oramodMetricsPARSECNT Counter
  oramodMetricsCPUTM INTEGER
  oramodMetricsLOGFILESWTCH INTEGER
  oramodMetricsARCHIVER DisplayString
  oramodMetricsDATABASESTATUS DisplayString
  oramodMetricsSHUTDOWNPENDING DisplayString
  oramodMetricsLASTUPDATE TimeTicks

OramodSgaDddAggEntry  
SEQUENCE    
  oramodSGAAGGSIDINDX INTEGER
  oramodSGAAGGCNT Counter
  oramodSGAAGGUSGE Counter
  oramodSGAAGGFIX Counter
  oramodSGAAGGGET Counter
  oramodSGAAGGGETMISS Counter
  oramodSGAAGGSCAN Counter
  oramodSGAAGGSCANMISS Counter
  oramodSGAAGGSCANCPLT Counter
  oramodSGAAGGMODS Counter
  oramodSGAAGGFLUSH Counter

OramodSgaDlciEntry  
SEQUENCE    
  oramodSGADLCISIDINDX INTEGER
  oramodSGADLCIINDX INTEGER
  oramodSGADLCINAME DisplayString
  oramodSGADLCIGET Counter
  oramodSGADLCIGETHIT Counter
  oramodSGADLCIGETHITRT Gauge
  oramodSGADLCIPIN Counter
  oramodSGADLCIPINHIT Counter
  oramodSGADLCIPINHITRT Gauge
  oramodSGADLCIRELOAD Counter
  oramodSGADLCIINVALID Counter

OramodRedoLogBufEntry  
SEQUENCE    
  oramodREDOSIDINDX INTEGER
  oramodREDOBLKWRT Counter
  oramodREDOENTRIES Counter
  oramodREDOSIZE INTEGER
  oramodREDOSPACERQST Counter
  oramodREDOSPACEWAIT Counter
  oramodREDOSYNCHWRT Counter
  oramodREDOSYNCHTM INTEGER
  oramodREDOWASTAGE Counter
  oramodREDORETRIES Counter
  oramodREDOLASTUPDATE TimeTicks

OramodRollBackEntry  
SEQUENCE    
  oramodRollBackSIDINDX INTEGER
  oramodRollBackSEGINDX INTEGER
  oramodRollBackSEGNAME DisplayString
  oramodRollBackEXTENTS Counter
  oramodRollBackRSSIZE Counter
  oramodRollBackWRITES Counter
  oramodRollBackGETS Counter
  oramodRollBackWAITS Counter
  oramodRollBackOPTSIZE INTEGER
  oramodRollBackSHRINKS Counter
  oramodRollBackWRAPS Counter
  oramodRollBackEXTENDS Counter
  oramodRollBackAVESHRINK INTEGER
  oramodRollBackAVEACTIVE Counter
  oramodRollBackSTATUS INTEGER

OramodWaitsEntry  
SEQUENCE    
  oramodWaitsSIDINDX INTEGER
  oramodWaitsEVENTINDX INTEGER
  oramodWaitsEVENT DisplayString
  oramodWaitsTOTALWAITS Counter
  oramodWaitsTOTALTIMOUT Counter
  oramodWaitsTIMEWAITED Counter
  oramodWaitsAVGWAIT Counter

OramodExpSqlEntry  
SEQUENCE    
  oramodExpSqlSIDINDX INTEGER
  oramodExpSqlSQLINDX INTEGER
  oramodExpSqlEXECUTION Gauge
  oramodExpSqlDISKREAD Gauge
  oramodExpSqlPARSECNT Gauge
  oramodExpSqlBUFFGETS Gauge
  oramodExpSqlSORTS Gauge
  oramodExpSqlSQL DisplayString

OramodTblspEntry  
SEQUENCE    
  oramodTblspSIDINDX INTEGER
  oramodTblspTBLSPINDX INTEGER
  oramodTblspTBLSPNAME DisplayString
  oramodTblspFILENAME DisplayString
  oramodTblspEXTENTS Gauge
  oramodTblspLRGEXTENT Gauge
  oramodTblspSMEXTENT Gauge
  oramodTblspINCREMENTBY INTEGER
  oramodTblspBYTESCOALSD Gauge
  oramodTblspBYTESFREE Gauge

OramodLockEntry  
SEQUENCE    
  oramodLockSIDINDX INTEGER
  oramodLockUSERINDX INTEGER
  oramodLockUSERNAME DisplayString
  oramodLockOBJECT DisplayString
  oramodLockTYPE DisplayString
  oramodLockMODE INTEGER
  oramodLockCTIME INTEGER
  oramodLockBLOCK INTEGER

OramodLatchEntry  
SEQUENCE    
  oramodLatchSIDINDX INTEGER
  oramodLatchLATCHINDX INTEGER
  oramodLatchLATCHNUM INTEGER
  oramodLatchLATCHNAME DisplayString
  oramodLatchGETS Counter
  oramodLatchMISSES Counter
  oramodLatchSLEEPS Counter
  oramodLatchIMDGETS Counter
  oramodLatchIMDMISSES Counter
  oramodLatchWAITSHOLDING Counter
  oramodLatchSPINGETS Counter

OramodBackupEntry  
SEQUENCE    
  oramodBackupSIDINDX INTEGER
  oramodBackupFILENUM INTEGER
  oramodBackupSTATUS DisplayString
  oramodBackupCHANGENUM INTEGER
  oramodBackupDATE DisplayString

OramodArcDestEntry  
SEQUENCE    
  oramodArcDestSIDINDX INTEGER
  oramodArcDestARCINDX INTEGER
  oramodArcDestARCMODE DisplayString
  oramodArcDestSTATUS DisplayString
  oramodArcDestDEST DisplayString

Defined Values

empire 1.3.6.1.4.1.546
OBJECT IDENTIFIER    

applications 1.3.6.1.4.1.546.16
OBJECT IDENTIFIER    

oracledb 1.3.6.1.4.1.546.16.4
OBJECT IDENTIFIER    

oramodTtlFootprt 1.3.6.1.4.1.546.16.4.12
OBJECT IDENTIFIER    

oramodCfg 1.3.6.1.4.1.546.16.4.10
OBJECT IDENTIFIER    

oramodDbCfg 1.3.6.1.4.1.546.16.4.10.1
OBJECT IDENTIFIER    

oramodCfgDf 1.3.6.1.4.1.546.16.4.10.2
OBJECT IDENTIFIER    

oramodCfgLf 1.3.6.1.4.1.546.16.4.10.3
OBJECT IDENTIFIER    

oramodCfgSga 1.3.6.1.4.1.546.16.4.10.4
OBJECT IDENTIFIER    

oramodPerf 1.3.6.1.4.1.546.16.4.11
OBJECT IDENTIFIER    

oramodFootprint 1.3.6.1.4.1.546.16.4.11.1
OBJECT IDENTIFIER    

oramodMetrics 1.3.6.1.4.1.546.16.4.11.2
OBJECT IDENTIFIER    

oramodSGA 1.3.6.1.4.1.546.16.4.11.3
OBJECT IDENTIFIER    

oramodRedoLogBuf 1.3.6.1.4.1.546.16.4.11.4
OBJECT IDENTIFIER    

oramodRollBack 1.3.6.1.4.1.546.16.4.11.5
OBJECT IDENTIFIER    

oramodWaits 1.3.6.1.4.1.546.16.4.11.6
OBJECT IDENTIFIER    

oramodExpSql 1.3.6.1.4.1.546.16.4.11.7
OBJECT IDENTIFIER    

oramodTblsp 1.3.6.1.4.1.546.16.4.11.8
OBJECT IDENTIFIER    

oramodLocks 1.3.6.1.4.1.546.16.4.11.9
OBJECT IDENTIFIER    

oramodBackups 1.3.6.1.4.1.546.16.4.11.10
OBJECT IDENTIFIER    

oramodArchive 1.3.6.1.4.1.546.16.4.11.11
OBJECT IDENTIFIER    

oramodFootprt 1.3.6.1.4.1.546.16.4.11.1.1
OBJECT IDENTIFIER    

oramodFFootprt 1.3.6.1.4.1.546.16.4.11.1.2
OBJECT IDENTIFIER    

oramodSgaDddAgg 1.3.6.1.4.1.546.16.4.11.3.1
OBJECT IDENTIFIER    

oramodSgaDlci 1.3.6.1.4.1.546.16.4.11.3.2
OBJECT IDENTIFIER    

oramodLock 1.3.6.1.4.1.546.16.4.11.9.1
OBJECT IDENTIFIER    

oramodLatch 1.3.6.1.4.1.546.16.4.11.9.2
OBJECT IDENTIFIER    

oramodBackup 1.3.6.1.4.1.546.16.4.11.10.1
OBJECT IDENTIFIER    

oramodArcDest 1.3.6.1.4.1.546.16.4.11.11.1
OBJECT IDENTIFIER    

oraModVersion 1.3.6.1.4.1.546.16.4.1
Description and version number of this installation.
OBJECT-TYPE    
  DisplayString  

oraModMode 1.3.6.1.4.1.546.16.4.2
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)
OBJECT-TYPE    
  INTEGER fullMode(1), restrictedMode(2)  

oraFlag 1.3.6.1.4.1.546.16.4.3
Performance flags for this installation.
OBJECT-TYPE    
  DisplayString  

oramodTtlCPUTIME 1.3.6.1.4.1.546.16.4.12.1
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.
OBJECT-TYPE    
  INTEGER  

oramodTtlPERCENTCPU 1.3.6.1.4.1.546.16.4.12.2
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'
OBJECT-TYPE    
  INTEGER 0..100  

oramodTtlMEMSIZE 1.3.6.1.4.1.546.16.4.12.3
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.
OBJECT-TYPE    
  Gauge  

oramodTtlRSS 1.3.6.1.4.1.546.16.4.12.4
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.
OBJECT-TYPE    
  Gauge  

oramodTtlPERCENTMEM 1.3.6.1.4.1.546.16.4.12.5
The percentage (0-100) of real memory used by the Oracle Application which includes core services and optional connectors.
OBJECT-TYPE    
  INTEGER 0..100  

oramodTtlTHREADS 1.3.6.1.4.1.546.16.4.12.6
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.
OBJECT-TYPE    
  Gauge  

oramodTtlINBLKS 1.3.6.1.4.1.546.16.4.12.7
The number of blocks of data input by the processes.
OBJECT-TYPE    
  Gauge  

oramodTtlOUTBLKS 1.3.6.1.4.1.546.16.4.12.8
The number of blocks of data put by the processes.
OBJECT-TYPE    
  Gauge  

oramodTtlMSGSSENT 1.3.6.1.4.1.546.16.4.12.9
The number of messages sent by the processes.
OBJECT-TYPE    
  Counter  

oramodTtlMSGSRCVD 1.3.6.1.4.1.546.16.4.12.10
The number of messages received by the processes.
OBJECT-TYPE    
  Counter  

oramodTtlSYSCALLS 1.3.6.1.4.1.546.16.4.12.11
The number of system calls invoked by the processes.
OBJECT-TYPE    
  Counter  

oramodTtlMINORPGFLTS 1.3.6.1.4.1.546.16.4.12.12
The number of minor page faults incurred by the process. Minor faults do not require I/O to retrieve the page.
OBJECT-TYPE    
  Counter  

oramodTtlMAJORPGFLTS 1.3.6.1.4.1.546.16.4.12.13
The number of major page faults incurred by the process. Minor faults require I/O to retrieve the page.
OBJECT-TYPE    
  Counter  

oramodTtlNUMSWAPS 1.3.6.1.4.1.546.16.4.12.14
The number of times the processes have been swapped.
OBJECT-TYPE    
  Counter  

oramodTtlVOLCNTX 1.3.6.1.4.1.546.16.4.12.15
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).
OBJECT-TYPE    
  Counter  

oramodTtlINVOLCNTX 1.3.6.1.4.1.546.16.4.12.16
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.
OBJECT-TYPE    
  Counter  

oramodTtlDISKSIZE 1.3.6.1.4.1.546.16.4.12.17
The size, in KBytes of the Oracle root directory and all the Database Disk storage areas.
OBJECT-TYPE    
  INTEGER  

oramodDbCfgTable 1.3.6.1.4.1.546.16.4.10.1.1
This table describes the instance names, index numbers and initial startup information.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodDbCfgEntry

oramodDbCfgEntry 1.3.6.1.4.1.546.16.4.10.1.1.1
An entry in the Oracle Configuration table.
OBJECT-TYPE    
  OramodDbCfgEntry  

oramodDbCfgSIDINDX 1.3.6.1.4.1.546.16.4.10.1.1.1.1
Sid's Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgSID 1.3.6.1.4.1.546.16.4.10.1.1.1.2
Database Name.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgVERSION 1.3.6.1.4.1.546.16.4.10.1.1.1.3
Description and version of this Oracle installation from v
OBJECT-TYPE    
  DisplayString  

oramodDbCfgHOME 1.3.6.1.4.1.546.16.4.10.1.1.1.4
The Installation Directory for Oracle or ORACLEHOME.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgBASE 1.3.6.1.4.1.546.16.4.10.1.1.1.5
The Base Directory for Oracle or ORACLEBASE.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgID 1.3.6.1.4.1.546.16.4.10.1.1.1.6
The database ID calculated when the database is created and stored in all file headers (521382036).
OBJECT-TYPE    
  INTEGER  

oramodDbCfgCRTDT 1.3.6.1.4.1.546.16.4.10.1.1.1.7
The original creation date and time of the database.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgLOGMODE 1.3.6.1.4.1.546.16.4.10.1.1.1.8
The Archive log mode: NOARCHIVELOG or ARCHIVELOG.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgCTRLFILETYPE 1.3.6.1.4.1.546.16.4.10.1.1.1.9
Control File Type. Can be the following types : CURRENT,STANDBY,CLONE,BACKUP,CREATED.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgOPENMODE 1.3.6.1.4.1.546.16.4.10.1.1.1.10
Shows whether the database is set to READ WRITE or READ ONLY (NEW TO 8i.).
OBJECT-TYPE    
  DisplayString  

oramodDbCfgMAXPROCESS 1.3.6.1.4.1.546.16.4.10.1.1.1.11
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
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgMAXSESSION 1.3.6.1.4.1.546.16.4.10.1.1.1.12
Maximum number of User and System Sessions.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgTIMEDSTATISTICS 1.3.6.1.4.1.546.16.4.10.1.1.1.13
TRUE/FALSE: sets timing on. Should be false for maximum performance.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgCPUCNT 1.3.6.1.4.1.546.16.4.10.1.1.1.14
The maximum number of CPU's for this instance.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgSHAREDPOOLSIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.15
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.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgSHAREDPOOLRSSIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.16
Shared Pool Reserved Size Kbytes.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgLARGEPOOLSIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.17
Large Pool Reserved Size Kbytes.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgJAVAPOOLSIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.18
Java Pool Size in Kbytes Default is (20000K)
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgCNTRLFILES 1.3.6.1.4.1.546.16.4.10.1.1.1.19
Name and path of control files. String of file names.
OBJECT-TYPE    
  DisplayString  

oramodDbCfgDBBLKBUFF 1.3.6.1.4.1.546.16.4.10.1.1.1.20
Number of Database Block Buffers in blocks. Controls how much memory is available in the buffer cache for data blocks. Default is (26240)
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgDBBLKSIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.21
Size of Database Blocks. O/S dependent
OBJECT-TYPE    
  INTEGER 1024..8192  

oramodDbCfgCKPTINTRVL 1.3.6.1.4.1.546.16.4.10.1.1.1.22
Redo Log Checkpoint Interval.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgDBFILES 1.3.6.1.4.1.546.16.4.10.1.1.1.23
Maximum Number of Database Files.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgSORTAREASIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.24
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.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgOPENCURSORS 1.3.6.1.4.1.546.16.4.10.1.1.1.25
Maximum open cursors a single-user process can have at once. Typical Range (1 - 2147483647).
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgTRNSACTNS 1.3.6.1.4.1.546.16.4.10.1.1.1.26
Maximum number of concurrent transactions allowed at one time.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgTRNSACTNSPERSEG 1.3.6.1.4.1.546.16.4.10.1.1.1.27
Maximum number of concurrent transactions per segment. Default is 30. O/S dependent.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodDbCfgMAXROLLSEG 1.3.6.1.4.1.546.16.4.10.1.1.1.28
Maximum number of rollback segments.
OBJECT-TYPE    
  INTEGER 1..65536  

oramodCfgDfTable 1.3.6.1.4.1.546.16.4.10.2.1
This table describes the database files for the database.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodCfgDfEntry

oramodCfgDfEntry 1.3.6.1.4.1.546.16.4.10.2.1.1
An entry in the Oracle v table.
OBJECT-TYPE    
  OramodCfgDfEntry  

oramodCfgDfSIDINDX 1.3.6.1.4.1.546.16.4.10.2.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgDfFILENUM 1.3.6.1.4.1.546.16.4.10.2.1.1.2
File Identification Number.
OBJECT-TYPE    
  INTEGER  

oramodCfgDfSTATUS 1.3.6.1.4.1.546.16.4.10.2.1.1.3
Type of file (system or user) and its status. Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF(an offline file from the SYSTEM tablespace).
OBJECT-TYPE    
  DisplayString  

oramodCfgDfENABLED 1.3.6.1.4.1.546.16.4.10.2.1.1.4
Describes how accessible the file is from SQL. Can be DISABLED, READ ONLY, READ WRITE and UNKNOWN.
OBJECT-TYPE    
  DisplayString  

oramodCfgDfUNRCVRBLECHG 1.3.6.1.4.1.546.16.4.10.2.1.1.5
The last unrecoverbale change number made to this datafile. Always updated when an unrecoverable operation completes.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgDfUNRCVRBLETIME 1.3.6.1.4.1.546.16.4.10.2.1.1.6
The last unrecoverbale change time made to this datafile. Always updated when an unrecoverable operation completes.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgDfKBYTES 1.3.6.1.4.1.546.16.4.10.2.1.1.7
Current size in kbytes; 0 if unaccessible.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgDfCRTKBYTES 1.3.6.1.4.1.546.16.4.10.2.1.1.8
Size when created.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgDfFNAME 1.3.6.1.4.1.546.16.4.10.2.1.1.9
Name of the file.
OBJECT-TYPE    
  DisplayString  

oramodCfgDfCRTTIME 1.3.6.1.4.1.546.16.4.10.2.1.1.10
Time at which the datafile was created.
OBJECT-TYPE    
  DisplayString  

oramodCfgDfTBLESPACENUM 1.3.6.1.4.1.546.16.4.10.2.1.1.11
Tablespace Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgDfTBLESPACERFILENUM 1.3.6.1.4.1.546.16.4.10.2.1.1.12
Tablespace Relative Df Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgDfBLOCKS 1.3.6.1.4.1.546.16.4.10.2.1.1.13
Current datafile size in blocks; 0 if inaccessible.
OBJECT-TYPE    
  INTEGER 0..2147483647  

oramodCfgDfBLOCKSIZE 1.3.6.1.4.1.546.16.4.10.2.1.1.14
Block size of the datafile.
OBJECT-TYPE    
  INTEGER 0..2147483647  

oramodCfgDfERROR 1.3.6.1.4.1.546.16.4.10.2.1.1.15
NULL if the header read success. If error must restore.
OBJECT-TYPE    
  INTEGER 0..2147483647  

oramodCfgDfRECOVER 1.3.6.1.4.1.546.16.4.10.2.1.1.16
YES/NO File needs media recovery.
OBJECT-TYPE    
  DisplayString  

oramodCfgDfRSTLOGSCHGNUM 1.3.6.1.4.1.546.16.4.10.2.1.1.17
Reset Logs change number.
OBJECT-TYPE    
  INTEGER 0..2147483647  

oramodCfgDfRSTLOGSTIME 1.3.6.1.4.1.546.16.4.10.2.1.1.18
Reset Logs timestamp.
OBJECT-TYPE    
  DisplayString  

oramodCfgLfTable 1.3.6.1.4.1.546.16.4.10.3.1
This table describes the redo log files locations for each Oracle installation from v.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodCfgLfEntry

oramodCfgLfEntry 1.3.6.1.4.1.546.16.4.10.3.1.1
An entry in the Oracle Logfile table.
OBJECT-TYPE    
  OramodCfgLfEntry  

oramodCfgLfSIDINDX 1.3.6.1.4.1.546.16.4.10.3.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgLfMEMBERINDX 1.3.6.1.4.1.546.16.4.10.3.1.1.2
Logfile member index.
OBJECT-TYPE    
  INTEGER 1..2147482647  

oramodCfgLfGROUPNUM 1.3.6.1.4.1.546.16.4.10.3.1.1.3
Group Number.
OBJECT-TYPE    
  INTEGER 1..2147482647  

oramodCfgLfSTATUS 1.3.6.1.4.1.546.16.4.10.3.1.1.4
Status of File.
OBJECT-TYPE    
  DisplayString  

oramodCfgLfMEMBER 1.3.6.1.4.1.546.16.4.10.3.1.1.5
File name and path.
OBJECT-TYPE    
  DisplayString  

oramodCfgSgaTable 1.3.6.1.4.1.546.16.4.10.4.1
This table summarizes the system global area.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodCfgSgaEntry

oramodCfgSgaEntry 1.3.6.1.4.1.546.16.4.10.4.1.1
An entry in the Oracle Sga table.
OBJECT-TYPE    
  OramodCfgSgaEntry  

oramodCfgSgaSIDINDX 1.3.6.1.4.1.546.16.4.10.4.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgSgaTOTALMEMALLOC 1.3.6.1.4.1.546.16.4.10.4.1.1.2
Total real memory allocated. Summation of values in v.
OBJECT-TYPE    
  INTEGER 1..2147482647  

oramodCfgSgaFIXEDSGA 1.3.6.1.4.1.546.16.4.10.4.1.1.3
Fixed memory allocated in Kbytes
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgSgaVARIABLE 1.3.6.1.4.1.546.16.4.10.4.1.1.4
Variable Memory allocated in the SGA
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgSgaDBBUFF 1.3.6.1.4.1.546.16.4.10.4.1.1.5
Database buffers allocated in Kbytes. Typical Range is 4 Kbytes - 2 Gbytes.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodCfgSgaREDOBUFF 1.3.6.1.4.1.546.16.4.10.4.1.1.6
Redo Buffers allocated in Kbytes
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodFootprtTable 1.3.6.1.4.1.546.16.4.11.1.1.1
This table describes the system footprint.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodFootprtEntry

oramodFootprtEntry 1.3.6.1.4.1.546.16.4.11.1.1.1.1
An entry in the Oracle Footprint table.
OBJECT-TYPE    
  OramodFootprtEntry  

oramodFootprtSIDINDX 1.3.6.1.4.1.546.16.4.11.1.1.1.1.1
Empire's Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodFootprtCPUTIME 1.3.6.1.4.1.546.16.4.11.1.1.1.1.2
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.
OBJECT-TYPE    
  INTEGER  

oramodFootprtPERCENTCPU 1.3.6.1.4.1.546.16.4.11.1.1.1.1.3
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'
OBJECT-TYPE    
  INTEGER 0..100  

oramodFootprtMEMSIZE 1.3.6.1.4.1.546.16.4.11.1.1.1.1.4
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.
OBJECT-TYPE    
  Gauge  

oramodFootprtRSS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.5
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.
OBJECT-TYPE    
  Gauge  

oramodFootprtPERCENTMEM 1.3.6.1.4.1.546.16.4.11.1.1.1.1.6
The percentage (0-100) of real memory used by the Oracle Application which includes core services and optional connectors.
OBJECT-TYPE    
  INTEGER 0..100  

oramodFootprtTHREADS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.7
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.
OBJECT-TYPE    
  Gauge  

oramodFootprtINBLKS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.8
The number of blocks of data input by the processes.
OBJECT-TYPE    
  Gauge  

oramodFootprtOUTBLKS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.9
The number of blocks of data put by the processes.
OBJECT-TYPE    
  Gauge  

oramodFootprtMSGSSENT 1.3.6.1.4.1.546.16.4.11.1.1.1.1.10
The number of messages sent by the processes.
OBJECT-TYPE    
  Counter  

oramodFootprtMSGSRCVD 1.3.6.1.4.1.546.16.4.11.1.1.1.1.11
The number of messages received by the processes.
OBJECT-TYPE    
  Counter  

oramodFootprtSYSCALLS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.12
The number of system calls invoked by the processes.
OBJECT-TYPE    
  Counter  

oramodFootprtMINORPGFLTS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.13
The number of minor page faults incurred by the process. Minor faults do not require I/O to retrieve the page.
OBJECT-TYPE    
  Counter  

oramodFootprtMAJORPGFLTS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.14
The number of major page faults incurred by the process. Minor faults require I/O to retrieve the page.
OBJECT-TYPE    
  Counter  

oramodFootprtNUMSWAPS 1.3.6.1.4.1.546.16.4.11.1.1.1.1.15
The number of times the processes have been swapped.
OBJECT-TYPE    
  Counter  

oramodFootprtVOLCNTX 1.3.6.1.4.1.546.16.4.11.1.1.1.1.16
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).
OBJECT-TYPE    
  Counter  

oramodFootprtINVOLCNTX 1.3.6.1.4.1.546.16.4.11.1.1.1.1.17
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.
OBJECT-TYPE    
  Counter  

oramodFootprtHOMESIZE 1.3.6.1.4.1.546.16.4.11.1.1.1.1.18
The size, in KBytes of the Oracle root directory and all files beneath it.
OBJECT-TYPE    
  Gauge  

oramodFootprtDBDISKSIZE 1.3.6.1.4.1.546.16.4.11.1.1.1.1.19
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.
OBJECT-TYPE    
  Gauge  

oramodFootprtLASTUPDATE 1.3.6.1.4.1.546.16.4.11.1.1.1.1.20
The time (based on sysUpTime) that the last update of all variables in the table was completed.
OBJECT-TYPE    
  TimeTicks  

oramodFFootprtTable 1.3.6.1.4.1.546.16.4.11.1.2.1
This table describes the system footprint.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodFFootprtEntry

oramodFFootprtEntry 1.3.6.1.4.1.546.16.4.11.1.2.1.1
An entry in the Oracle File Footprint table.
OBJECT-TYPE    
  OramodFFootprtEntry  

oramodFFootprtSIDINDX 1.3.6.1.4.1.546.16.4.11.1.2.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodFFootprtFILEINDX 1.3.6.1.4.1.546.16.4.11.1.2.1.1.2
File Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodFFootprtFILETYPE 1.3.6.1.4.1.546.16.4.11.1.2.1.1.3
File Type.
OBJECT-TYPE    
  DisplayString  

oramodFFootprtFILENAME 1.3.6.1.4.1.546.16.4.11.1.2.1.1.4
File Name.
OBJECT-TYPE    
  DisplayString  

oramodFFootprtCRTTS 1.3.6.1.4.1.546.16.4.11.1.2.1.1.5
Last update timestamp.
OBJECT-TYPE    
  DisplayString  

oramodFFootprtCRTKBYTES 1.3.6.1.4.1.546.16.4.11.1.2.1.1.6
File creation kbytes.
OBJECT-TYPE    
  INTEGER  

oramodFFootprtKBYTES 1.3.6.1.4.1.546.16.4.11.1.2.1.1.7
File kbytes.
OBJECT-TYPE    
  INTEGER  

oramodFFootprtBLOCKS 1.3.6.1.4.1.546.16.4.11.1.2.1.1.8
File blocks.
OBJECT-TYPE    
  INTEGER  

oramodFFootprtSTATUS 1.3.6.1.4.1.546.16.4.11.1.2.1.1.9
File Status.
OBJECT-TYPE    
  DisplayString  

oramodFFootprtRECOVER 1.3.6.1.4.1.546.16.4.11.1.2.1.1.10
Last Recover timestamp.
OBJECT-TYPE    
  DisplayString  

oramodFFootprtAVGIOTIM 1.3.6.1.4.1.546.16.4.11.1.2.1.1.11
File average I/O time.
OBJECT-TYPE    
  DisplayString  

oramodMetricsTable 1.3.6.1.4.1.546.16.4.11.2.1
This table describes the database metrics.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodMetricsEntry

oramodMetricsEntry 1.3.6.1.4.1.546.16.4.11.2.1.1
An entry in the Metrics table.
OBJECT-TYPE    
  OramodMetricsEntry  

oramodMetricsSIDINDX 1.3.6.1.4.1.546.16.4.11.2.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodMetricsBCPT 1.3.6.1.4.1.546.16.4.11.2.1.1.2
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsBGR 1.3.6.1.4.1.546.16.4.11.2.1.1.3
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsBVPT 1.3.6.1.4.1.546.16.4.11.2.1.1.4
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsCHR 1.3.6.1.4.1.546.16.4.11.2.1.1.5
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsCR 1.3.6.1.4.1.546.16.4.11.2.1.1.6
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsCPT 1.3.6.1.4.1.546.16.4.11.2.1.1.7
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsCBR 1.3.6.1.4.1.546.16.4.11.2.1.1.8
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsCCR 1.3.6.1.4.1.546.16.4.11.2.1.1.9
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsCRR 1.3.6.1.4.1.546.16.4.11.2.1.1.10
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsLCM 1.3.6.1.4.1.546.16.4.11.2.1.1.11
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsRTUC 1.3.6.1.4.1.546.16.4.11.2.1.1.12
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsRLSW 1.3.6.1.4.1.546.16.4.11.2.1.1.13
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsRSR 1.3.6.1.4.1.546.16.4.11.2.1.1.14
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsSOR 1.3.6.1.4.1.546.16.4.11.2.1.1.15
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsTRR 1.3.6.1.4.1.546.16.4.11.2.1.1.16
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsUCR 1.3.6.1.4.1.546.16.4.11.2.1.1.17
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsUCPP 1.3.6.1.4.1.546.16.4.11.2.1.1.18
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsURR 1.3.6.1.4.1.546.16.4.11.2.1.1.19
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsSGALCE 1.3.6.1.4.1.546.16.4.11.2.1.1.20
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsSGADDCE 1.3.6.1.4.1.546.16.4.11.2.1.1.21
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsDBTOTALRW 1.3.6.1.4.1.546.16.4.11.2.1.1.22
The total number of physical reads and physical writes since instance startup. See individual descriptions below.
OBJECT-TYPE    
  Counter  

oramodMetricsDBBLKCHG 1.3.6.1.4.1.546.16.4.11.2.1.1.23
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.
OBJECT-TYPE    
  Counter  

oramodMetricsDBBLKGET 1.3.6.1.4.1.546.16.4.11.2.1.1.24
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.
OBJECT-TYPE    
  Counter  

oramodMetricsDBCNSTGET 1.3.6.1.4.1.546.16.4.11.2.1.1.25
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.
OBJECT-TYPE    
  Counter  

oramodMetricsDBPHYSREAD 1.3.6.1.4.1.546.16.4.11.2.1.1.26
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.
OBJECT-TYPE    
  Counter  

oramodMetricsDBSORTDISK 1.3.6.1.4.1.546.16.4.11.2.1.1.27
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.
OBJECT-TYPE    
  Counter  

oramodMetricsDBSORTMEM 1.3.6.1.4.1.546.16.4.11.2.1.1.28
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.
OBJECT-TYPE    
  Counter  

oramodMetricsBLKFREEWAIT 1.3.6.1.4.1.546.16.4.11.2.1.1.29
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.
OBJECT-TYPE    
  Gauge  

oramodMetricsMTHRDQUEUEWAIT 1.3.6.1.4.1.546.16.4.11.2.1.1.30
The number of seconds waited in queue for multi-threaded servers.
OBJECT-TYPE    
  Gauge  

oramodMetricsSESSHIWTRMEM 1.3.6.1.4.1.546.16.4.11.2.1.1.31
The maximum highwater amount of session memory used.
OBJECT-TYPE    
  Counter  

oramodMetricsSESSCURRMEM 1.3.6.1.4.1.546.16.4.11.2.1.1.32
The current maximum amount of session memory used.
OBJECT-TYPE    
  Counter  

oramodMetricsSESSHIWTR 1.3.6.1.4.1.546.16.4.11.2.1.1.33
The highwater mark for number of sessions.
OBJECT-TYPE    
  Counter  

oramodMetricsSESSCURRENT 1.3.6.1.4.1.546.16.4.11.2.1.1.34
The current number of sessions.
OBJECT-TYPE    
  Gauge  

oramodMetricsUSERCOMMITS 1.3.6.1.4.1.546.16.4.11.2.1.1.35
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.
OBJECT-TYPE    
  Counter  

oramodMetricsUSERROLLBACK 1.3.6.1.4.1.546.16.4.11.2.1.1.36
The number of transactions rolled back since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsUSERCALLS 1.3.6.1.4.1.546.16.4.11.2.1.1.37
The number of transactions started since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsDBPHYSWRTS 1.3.6.1.4.1.546.16.4.11.2.1.1.38
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.
OBJECT-TYPE    
  Counter  

oramodMetricsTBLSCANROWS 1.3.6.1.4.1.546.16.4.11.2.1.1.39
The number of rows retrieved through table scans since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsTBLFTCHROWID 1.3.6.1.4.1.546.16.4.11.2.1.1.40
The number of rows retrieved through table fetches by rowid since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsTBLFTCHCROW 1.3.6.1.4.1.546.16.4.11.2.1.1.41
The number of rows retrieved through table fetches by continued row since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsRECRSVCALLS 1.3.6.1.4.1.546.16.4.11.2.1.1.42
The number of recursive calls since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsCNSTCHGS 1.3.6.1.4.1.546.16.4.11.2.1.1.43
The number of consistent changes since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsPARSECNT 1.3.6.1.4.1.546.16.4.11.2.1.1.44
The number of parses since instance startup.
OBJECT-TYPE    
  Counter  

oramodMetricsCPUTM 1.3.6.1.4.1.546.16.4.11.2.1.1.45
The amount of time taken to work requests.
OBJECT-TYPE    
  INTEGER  

oramodMetricsLOGFILESWTCH 1.3.6.1.4.1.546.16.4.11.2.1.1.46
The number of redo log file switches.
OBJECT-TYPE    
  INTEGER  

oramodMetricsARCHIVER 1.3.6.1.4.1.546.16.4.11.2.1.1.47
The database archiver.
OBJECT-TYPE    
  DisplayString  

oramodMetricsDATABASESTATUS 1.3.6.1.4.1.546.16.4.11.2.1.1.48
The status of the database.
OBJECT-TYPE    
  DisplayString  

oramodMetricsSHUTDOWNPENDING 1.3.6.1.4.1.546.16.4.11.2.1.1.49
The shutdown status of the database.
OBJECT-TYPE    
  DisplayString  

oramodMetricsLASTUPDATE 1.3.6.1.4.1.546.16.4.11.2.1.1.50
The time (based on sysUpTime) that the last update of all variables in the table was completed.
OBJECT-TYPE    
  TimeTicks  

oramodSgaDddAggTable 1.3.6.1.4.1.546.16.4.11.3.1.1
This table describes the data dictionary aggregates.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodSgaDddAggEntry

oramodSgaDddAggEntry 1.3.6.1.4.1.546.16.4.11.3.1.1.1
An entry in the Data Dictionary Aggregate table.
OBJECT-TYPE    
  OramodSgaDddAggEntry  

oramodSGAAGGSIDINDX 1.3.6.1.4.1.546.16.4.11.3.1.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodSGAAGGCNT 1.3.6.1.4.1.546.16.4.11.3.1.1.1.2
Total number of entries in the data dictionary cache since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGUSGE 1.3.6.1.4.1.546.16.4.11.3.1.1.1.3
The total number of cache entries with valid data since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGFIX 1.3.6.1.4.1.546.16.4.11.3.1.1.1.4
The total number of fixed entries in the data dictionary cache since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGGET 1.3.6.1.4.1.546.16.4.11.3.1.1.1.5
The total number of information requests since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGGETMISS 1.3.6.1.4.1.546.16.4.11.3.1.1.1.6
The total number of informations requests resulting in cache misses since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGSCAN 1.3.6.1.4.1.546.16.4.11.3.1.1.1.7
The total number of scan requests since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGSCANMISS 1.3.6.1.4.1.546.16.4.11.3.1.1.1.8
The total number of scan requests resulting in misses since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGSCANCPLT 1.3.6.1.4.1.546.16.4.11.3.1.1.1.9
For subordinate entries, the total number of times list was scanned completely since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGMODS 1.3.6.1.4.1.546.16.4.11.3.1.1.1.10
The total number of inserts, updates, and deletions since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGAAGGFLUSH 1.3.6.1.4.1.546.16.4.11.3.1.1.1.11
The total number of times flushed to disk since instance startup.
OBJECT-TYPE    
  Counter  

oramodSgaDlciTable 1.3.6.1.4.1.546.16.4.11.3.2.1
This table describes the detailed library cache information.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodSgaDlciEntry

oramodSgaDlciEntry 1.3.6.1.4.1.546.16.4.11.3.2.1.1
An entry in the Library Cache table.
OBJECT-TYPE    
  OramodSgaDlciEntry  

oramodSGADLCISIDINDX 1.3.6.1.4.1.546.16.4.11.3.2.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodSGADLCIINDX 1.3.6.1.4.1.546.16.4.11.3.2.1.1.2
Namespace Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodSGADLCINAME 1.3.6.1.4.1.546.16.4.11.3.2.1.1.3
Library Cache Namespace. (SQL AREA, TABLE/PROCEDURE, BODY, TRIGGER, INDEX, CLUSTER, OBJECT, PIPE)
OBJECT-TYPE    
  DisplayString  

oramodSGADLCIGET 1.3.6.1.4.1.546.16.4.11.3.2.1.1.4
The total number of request handles to library namespace since instance startup Typical range (0..500,00).
OBJECT-TYPE    
  Counter  

oramodSGADLCIGETHIT 1.3.6.1.4.1.546.16.4.11.3.2.1.1.5
The total number of times handles are already allocated in the cache. If the handle is not already allocated it is a miss.
OBJECT-TYPE    
  Counter  

oramodSGADLCIGETHITRT 1.3.6.1.4.1.546.16.4.11.3.2.1.1.6
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.
OBJECT-TYPE    
  Gauge  

oramodSGADLCIPIN 1.3.6.1.4.1.546.16.4.11.3.2.1.1.7
The total number of pin requests for objects in the cache since instance startup.
OBJECT-TYPE    
  Counter  

oramodSGADLCIPINHIT 1.3.6.1.4.1.546.16.4.11.3.2.1.1.8
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.
OBJECT-TYPE    
  Counter  

oramodSGADLCIPINHITRT 1.3.6.1.4.1.546.16.4.11.3.2.1.1.9
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.
OBJECT-TYPE    
  Gauge  

oramodSGADLCIRELOAD 1.3.6.1.4.1.546.16.4.11.3.2.1.1.10
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.
OBJECT-TYPE    
  Counter  

oramodSGADLCIINVALID 1.3.6.1.4.1.546.16.4.11.3.2.1.1.11
The number of times that non-persistant library objects (like SQL areas) have been invalidated.
OBJECT-TYPE    
  Counter  

oramodRedoLogBufTable 1.3.6.1.4.1.546.16.4.11.4.1
This table describes the Redo Log information.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodRedoLogBufEntry

oramodRedoLogBufEntry 1.3.6.1.4.1.546.16.4.11.4.1.1
An entry in the Redo Log table.
OBJECT-TYPE    
  OramodRedoLogBufEntry  

oramodREDOSIDINDX 1.3.6.1.4.1.546.16.4.11.4.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodREDOBLKWRT 1.3.6.1.4.1.546.16.4.11.4.1.1.2
The total number of redo blocks written since instance startup.
OBJECT-TYPE    
  Counter  

oramodREDOENTRIES 1.3.6.1.4.1.546.16.4.11.4.1.1.3
The total number of redo entries in the redo log since instance startup.
OBJECT-TYPE    
  Counter  

oramodREDOSIZE 1.3.6.1.4.1.546.16.4.11.4.1.1.4
The size of the redo log.
OBJECT-TYPE    
  INTEGER  

oramodREDOSPACERQST 1.3.6.1.4.1.546.16.4.11.4.1.1.5
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.
OBJECT-TYPE    
  Counter  

oramodREDOSPACEWAIT 1.3.6.1.4.1.546.16.4.11.4.1.1.6
The total number of redo log space wait time since instance startup
OBJECT-TYPE    
  Counter  

oramodREDOSYNCHWRT 1.3.6.1.4.1.546.16.4.11.4.1.1.7
The total number of redo synch writes since instance startup.
OBJECT-TYPE    
  Counter  

oramodREDOSYNCHTM 1.3.6.1.4.1.546.16.4.11.4.1.1.8
The amount of redo log synch time.
OBJECT-TYPE    
  INTEGER  

oramodREDOWASTAGE 1.3.6.1.4.1.546.16.4.11.4.1.1.9
The total amount of redo log wastage.
OBJECT-TYPE    
  Counter  

oramodREDORETRIES 1.3.6.1.4.1.546.16.4.11.4.1.1.10
The total number of redo retries.
OBJECT-TYPE    
  Counter  

oramodREDOLASTUPDATE 1.3.6.1.4.1.546.16.4.11.4.1.1.11
The time (based on sysUpTime) that the last update of all variables in the table was completed.
OBJECT-TYPE    
  TimeTicks  

oramodRollBackTable 1.3.6.1.4.1.546.16.4.11.5.1
This table describes any rollback segments.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodRollBackEntry

oramodRollBackEntry 1.3.6.1.4.1.546.16.4.11.5.1.1
An entry in the rollstat table.
OBJECT-TYPE    
  OramodRollBackEntry  

oramodRollBackSIDINDX 1.3.6.1.4.1.546.16.4.11.5.1.1.1
SID Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodRollBackSEGINDX 1.3.6.1.4.1.546.16.4.11.5.1.1.2
Undo Segment Number used as an index.
OBJECT-TYPE    
  INTEGER  

oramodRollBackSEGNAME 1.3.6.1.4.1.546.16.4.11.5.1.1.3
Rollback Segment Name.
OBJECT-TYPE    
  DisplayString  

oramodRollBackEXTENTS 1.3.6.1.4.1.546.16.4.11.5.1.1.4
The total number of Segment Extends since instance startup.
OBJECT-TYPE    
  Counter  

oramodRollBackRSSIZE 1.3.6.1.4.1.546.16.4.11.5.1.1.5
The size of the Rollback Segment.
OBJECT-TYPE    
  Counter  

oramodRollBackWRITES 1.3.6.1.4.1.546.16.4.11.5.1.1.6
The total number of Segment Writes since instance startup.
OBJECT-TYPE    
  Counter  

oramodRollBackGETS 1.3.6.1.4.1.546.16.4.11.5.1.1.7
The total number of Rollback Segment Gets since instance startup.
OBJECT-TYPE    
  Counter  

oramodRollBackWAITS 1.3.6.1.4.1.546.16.4.11.5.1.1.8
The total number of Segment Waits since instance startup.
OBJECT-TYPE    
  Counter  

oramodRollBackOPTSIZE 1.3.6.1.4.1.546.16.4.11.5.1.1.9
The Optimal Size of the Rollback Segment. This size should be set based on application usage to minimize space management issues.
OBJECT-TYPE    
  INTEGER  

oramodRollBackSHRINKS 1.3.6.1.4.1.546.16.4.11.5.1.1.10
The total number of Rollback Segment Shrinks since instance startup. Rollback Segments shrink back to their optimal size after extends have occurred.
OBJECT-TYPE    
  Counter  

oramodRollBackWRAPS 1.3.6.1.4.1.546.16.4.11.5.1.1.11
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.
OBJECT-TYPE    
  Counter  

oramodRollBackEXTENDS 1.3.6.1.4.1.546.16.4.11.5.1.1.12
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.
OBJECT-TYPE    
  Counter  

oramodRollBackAVESHRINK 1.3.6.1.4.1.546.16.4.11.5.1.1.13
The average shrink size of the Rollback Segment since this instance startup.
OBJECT-TYPE    
  INTEGER  

oramodRollBackAVEACTIVE 1.3.6.1.4.1.546.16.4.11.5.1.1.14
Segment average active.
OBJECT-TYPE    
  Counter  

oramodRollBackSTATUS 1.3.6.1.4.1.546.16.4.11.5.1.1.15
Segment status.
OBJECT-TYPE    
  INTEGER  

oramodWaitsTable 1.3.6.1.4.1.546.16.4.11.6.1
This table describes resource waits.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodWaitsEntry

oramodWaitsEntry 1.3.6.1.4.1.546.16.4.11.6.1.1
An entry in the waits table.
OBJECT-TYPE    
  OramodWaitsEntry  

oramodWaitsSIDINDX 1.3.6.1.4.1.546.16.4.11.6.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodWaitsEVENTINDX 1.3.6.1.4.1.546.16.4.11.6.1.1.2
Event's Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodWaitsEVENT 1.3.6.1.4.1.546.16.4.11.6.1.1.3
Resource Name.
OBJECT-TYPE    
  DisplayString  

oramodWaitsTOTALWAITS 1.3.6.1.4.1.546.16.4.11.6.1.1.4
Resource Total Waits.
OBJECT-TYPE    
  Counter  

oramodWaitsTOTALTIMOUT 1.3.6.1.4.1.546.16.4.11.6.1.1.5
Resource Total Timeouts.
OBJECT-TYPE    
  Counter  

oramodWaitsTIMEWAITED 1.3.6.1.4.1.546.16.4.11.6.1.1.6
Resource Total Waited.
OBJECT-TYPE    
  Counter  

oramodWaitsAVGWAIT 1.3.6.1.4.1.546.16.4.11.6.1.1.7
Resource average wait.
OBJECT-TYPE    
  Counter  

oramodExpSqlTable 1.3.6.1.4.1.546.16.4.11.7.1
This table describes expensive sql.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodExpSqlEntry

oramodExpSqlEntry 1.3.6.1.4.1.546.16.4.11.7.1.1
An entry in the v table.
OBJECT-TYPE    
  OramodExpSqlEntry  

oramodExpSqlSIDINDX 1.3.6.1.4.1.546.16.4.11.7.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodExpSqlSQLINDX 1.3.6.1.4.1.546.16.4.11.7.1.1.2
SQL Statement Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodExpSqlEXECUTION 1.3.6.1.4.1.546.16.4.11.7.1.1.3
Number of Executions.
OBJECT-TYPE    
  Gauge  

oramodExpSqlDISKREAD 1.3.6.1.4.1.546.16.4.11.7.1.1.4
Number of Disk Reads.
OBJECT-TYPE    
  Gauge  

oramodExpSqlPARSECNT 1.3.6.1.4.1.546.16.4.11.7.1.1.5
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.
OBJECT-TYPE    
  Gauge  

oramodExpSqlBUFFGETS 1.3.6.1.4.1.546.16.4.11.7.1.1.6
Number of Buffer Gets.
OBJECT-TYPE    
  Gauge  

oramodExpSqlSORTS 1.3.6.1.4.1.546.16.4.11.7.1.1.7
Number of Sorts.
OBJECT-TYPE    
  Gauge  

oramodExpSqlSQL 1.3.6.1.4.1.546.16.4.11.7.1.1.8
Sql Statement truncated.
OBJECT-TYPE    
  DisplayString  

oramodTblspTable 1.3.6.1.4.1.546.16.4.11.8.1
List Fragmentation Information.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodTblspEntry

oramodTblspEntry 1.3.6.1.4.1.546.16.4.11.8.1.1
An entry from the dbafreespace table.
OBJECT-TYPE    
  OramodTblspEntry  

oramodTblspSIDINDX 1.3.6.1.4.1.546.16.4.11.8.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodTblspTBLSPINDX 1.3.6.1.4.1.546.16.4.11.8.1.1.2
Tablespace Index Number.
OBJECT-TYPE    
  INTEGER 1..2147483647  

oramodTblspTBLSPNAME 1.3.6.1.4.1.546.16.4.11.8.1.1.3
Tablespace Name.
OBJECT-TYPE    
  DisplayString  

oramodTblspFILENAME 1.3.6.1.4.1.546.16.4.11.8.1.1.4
File Name.
OBJECT-TYPE    
  DisplayString  

oramodTblspEXTENTS 1.3.6.1.4.1.546.16.4.11.8.1.1.5
The number of extents.
OBJECT-TYPE    
  Gauge  

oramodTblspLRGEXTENT 1.3.6.1.4.1.546.16.4.11.8.1.1.6
Size in bytes of the largest extent.
OBJECT-TYPE    
  Gauge  

oramodTblspSMEXTENT 1.3.6.1.4.1.546.16.4.11.8.1.1.7
Size in bytes of the smallest extent.
OBJECT-TYPE    
  Gauge  

oramodTblspINCREMENTBY 1.3.6.1.4.1.546.16.4.11.8.1.1.8
Size in bytes of the next extent increment.
OBJECT-TYPE    
  INTEGER  

oramodTblspBYTESCOALSD 1.3.6.1.4.1.546.16.4.11.8.1.1.9
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.
OBJECT-TYPE    
  Gauge  

oramodTblspBYTESFREE 1.3.6.1.4.1.546.16.4.11.8.1.1.10
The total number of free bytes available.
OBJECT-TYPE    
  Gauge  

oramodLockTable 1.3.6.1.4.1.546.16.4.11.9.1.1
Lock Holders and Requestors
OBJECT-TYPE    
  SEQUENCE OF  
    OramodLockEntry

oramodLockEntry 1.3.6.1.4.1.546.16.4.11.9.1.1.1
An entry from the lock and session tables.
OBJECT-TYPE    
  OramodLockEntry  

oramodLockSIDINDX 1.3.6.1.4.1.546.16.4.11.9.1.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER  

oramodLockUSERINDX 1.3.6.1.4.1.546.16.4.11.9.1.1.1.2
User's Index Number.
OBJECT-TYPE    
  INTEGER  

oramodLockUSERNAME 1.3.6.1.4.1.546.16.4.11.9.1.1.1.3
User Name holding the lock.
OBJECT-TYPE    
  DisplayString  

oramodLockOBJECT 1.3.6.1.4.1.546.16.4.11.9.1.1.1.4
The name of the locked object.
OBJECT-TYPE    
  DisplayString  

oramodLockTYPE 1.3.6.1.4.1.546.16.4.11.9.1.1.1.5
Object Type.
OBJECT-TYPE    
  DisplayString  

oramodLockMODE 1.3.6.1.4.1.546.16.4.11.9.1.1.1.6
Lock Mode held (Null, Row share, Row exclusive, Share, Share row exclusive, Exclusive).
OBJECT-TYPE    
  INTEGER  

oramodLockCTIME 1.3.6.1.4.1.546.16.4.11.9.1.1.1.7
Time since current mode was granted.
OBJECT-TYPE    
  INTEGER  

oramodLockBLOCK 1.3.6.1.4.1.546.16.4.11.9.1.1.1.8
The lock is blocking another lock.
OBJECT-TYPE    
  INTEGER  

oramodLatchTable 1.3.6.1.4.1.546.16.4.11.9.2.1
Latch information.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodLatchEntry

oramodLatchEntry 1.3.6.1.4.1.546.16.4.11.9.2.1.1
An entry from the latch table.
OBJECT-TYPE    
  OramodLatchEntry  

oramodLatchSIDINDX 1.3.6.1.4.1.546.16.4.11.9.2.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER  

oramodLatchLATCHINDX 1.3.6.1.4.1.546.16.4.11.9.2.1.1.2
Latch Index Number.
OBJECT-TYPE    
  INTEGER  

oramodLatchLATCHNUM 1.3.6.1.4.1.546.16.4.11.9.2.1.1.3
Latch Number.
OBJECT-TYPE    
  INTEGER  

oramodLatchLATCHNAME 1.3.6.1.4.1.546.16.4.11.9.2.1.1.4
Latch Name.
OBJECT-TYPE    
  DisplayString  

oramodLatchGETS 1.3.6.1.4.1.546.16.4.11.9.2.1.1.5
Latch Gets. Reflects the proportion of times requests for latches are satisfied without waiting. Should be high.
OBJECT-TYPE    
  Counter  

oramodLatchMISSES 1.3.6.1.4.1.546.16.4.11.9.2.1.1.6
Latch Misses.
OBJECT-TYPE    
  Counter  

oramodLatchSLEEPS 1.3.6.1.4.1.546.16.4.11.9.2.1.1.7
Latch Sleeps.
OBJECT-TYPE    
  Counter  

oramodLatchIMDGETS 1.3.6.1.4.1.546.16.4.11.9.2.1.1.8
Latch Immediate Gets.
OBJECT-TYPE    
  Counter  

oramodLatchIMDMISSES 1.3.6.1.4.1.546.16.4.11.9.2.1.1.9
Latch Immediate Misses.
OBJECT-TYPE    
  Counter  

oramodLatchWAITSHOLDING 1.3.6.1.4.1.546.16.4.11.9.2.1.1.10
Latch Immediate Misses. When a session cannot acquire a latch, it goes into active wait and repeatedly trys to acquire the latch impaitiently.
OBJECT-TYPE    
  Counter  

oramodLatchSPINGETS 1.3.6.1.4.1.546.16.4.11.9.2.1.1.11
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.
OBJECT-TYPE    
  Counter  

oramodBackupTable 1.3.6.1.4.1.546.16.4.11.10.1.1
Backup Information
OBJECT-TYPE    
  SEQUENCE OF  
    OramodBackupEntry

oramodBackupEntry 1.3.6.1.4.1.546.16.4.11.10.1.1.1
An entry from the backup table.
OBJECT-TYPE    
  OramodBackupEntry  

oramodBackupSIDINDX 1.3.6.1.4.1.546.16.4.11.10.1.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER  

oramodBackupFILENUM 1.3.6.1.4.1.546.16.4.11.10.1.1.1.2
Backup File Index Number.
OBJECT-TYPE    
  INTEGER  

oramodBackupSTATUS 1.3.6.1.4.1.546.16.4.11.10.1.1.1.3
Status of the backup.
OBJECT-TYPE    
  DisplayString  

oramodBackupCHANGENUM 1.3.6.1.4.1.546.16.4.11.10.1.1.1.4
The change number of the backup file.
OBJECT-TYPE    
  INTEGER  

oramodBackupDATE 1.3.6.1.4.1.546.16.4.11.10.1.1.1.5
Date of the Backup.
OBJECT-TYPE    
  DisplayString  

oramodArcDestTable 1.3.6.1.4.1.546.16.4.11.11.1.1
Archive Information.
OBJECT-TYPE    
  SEQUENCE OF  
    OramodArcDestEntry

oramodArcDestEntry 1.3.6.1.4.1.546.16.4.11.11.1.1.1
An entry from the archive destination table.
OBJECT-TYPE    
  OramodArcDestEntry  

oramodArcDestSIDINDX 1.3.6.1.4.1.546.16.4.11.11.1.1.1.1
Sid Index Number.
OBJECT-TYPE    
  INTEGER  

oramodArcDestARCINDX 1.3.6.1.4.1.546.16.4.11.11.1.1.1.2
Index of Archive log.
OBJECT-TYPE    
  INTEGER  

oramodArcDestARCMODE 1.3.6.1.4.1.546.16.4.11.11.1.1.1.3
Mode of Archive log.
OBJECT-TYPE    
  DisplayString  

oramodArcDestSTATUS 1.3.6.1.4.1.546.16.4.11.11.1.1.1.4
Status of Archive Log File.
OBJECT-TYPE    
  DisplayString  

oramodArcDestDEST 1.3.6.1.4.1.546.16.4.11.11.1.1.1.5
Archive Log File Destination.
OBJECT-TYPE    
  DisplayString