EMPIRE-ORAMOD: View SNMP OID List / Download MIB

VENDOR: EMPIRE TECHNOLOGIES INC.


 Home MIB: EMPIRE-ORAMOD
Download as:   
SNMPv2-CONF, SNMPv2-SMI, SNMPv2-TC

Download standard MIB format if you are planning to load a MIB file into some system (OS, Zabbix, PRTG ...) or view it with a MIB browser. CSV is more suitable for analyzing and viewing OID' and other MIB objects in excel. JSON and YAML formats are usually used in programing even though some systems can use MIB in YAML format (like Logstash).
Keep in mind that standard MIB files can be successfully loaded by systems and programs only if all the required MIB's from the "Imports" section are already loaded.
The tree-like SNMP object navigator requires no explanations because it is very simple to use. And if you stumbled on this MIB from Google note that you can always go back to the home page if you need to perform another MIB or OID lookup.


Object Name OID Type Access Info
 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
                   oraModVersion 1.3.6.1.4.1.546.16.4.1 displaystring read-only
Description and version number of this installation.
                   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) Enumeration: 'restrictedMode': 2, 'fullMode': 1.
                   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 no-access
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 no-access
An entry in the Oracle Configuration table.
                                     oramodDbCfgSIDINDX 1.3.6.1.4.1.546.16.4.10.1.1.1.1 integer read-only
Sid's Index Number.
                                     oramodDbCfgSID 1.3.6.1.4.1.546.16.4.10.1.1.1.2 displaystring read-only
Database Name.
                                     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
                                     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.
                                     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.
                                     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).
                                     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.
                                     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.
                                     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.
                                     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.).
                                     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
                                     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.
                                     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.
                                     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.
                                     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.
                                     oramodDbCfgSHAREDPOOLRSSIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.16 integer read-only
Shared Pool Reserved Size Kbytes.
                                     oramodDbCfgLARGEPOOLSIZE 1.3.6.1.4.1.546.16.4.10.1.1.1.17 integer read-only
Large Pool Reserved Size Kbytes.
                                     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)
                                     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.
                                     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)
                                     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
                                     oramodDbCfgCKPTINTRVL 1.3.6.1.4.1.546.16.4.10.1.1.1.22 integer read-only
Redo Log Checkpoint Interval.
                                     oramodDbCfgDBFILES 1.3.6.1.4.1.546.16.4.10.1.1.1.23 integer read-only
Maximum Number of Database Files.
                                     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.
                                     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).
                                     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.
                                     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.
                                     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 no-access
This table describes the database files for the database.
                                 oramodCfgDfEntry 1.3.6.1.4.1.546.16.4.10.2.1.1 no-access
An entry in the Oracle v$datafile table.
                                     oramodCfgDfSIDINDX 1.3.6.1.4.1.546.16.4.10.2.1.1.1 integer read-only
Sid Index Number.
                                     oramodCfgDfFILENUM 1.3.6.1.4.1.546.16.4.10.2.1.1.2 integer read-only
File Identification Number.
                                     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).
                                     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.
                                     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.
                                     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.
                                     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.
                                     oramodCfgDfCRTKBYTES 1.3.6.1.4.1.546.16.4.10.2.1.1.8 integer read-only
Size when created.
                                     oramodCfgDfFNAME 1.3.6.1.4.1.546.16.4.10.2.1.1.9 displaystring read-only
Name of the file.
                                     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.
                                     oramodCfgDfTBLESPACENUM 1.3.6.1.4.1.546.16.4.10.2.1.1.11 integer read-only
Tablespace Number.
                                     oramodCfgDfTBLESPACERFILENUM 1.3.6.1.4.1.546.16.4.10.2.1.1.12 integer read-only
Tablespace Relative Df Number.
                                     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.
                                     oramodCfgDfBLOCKSIZE 1.3.6.1.4.1.546.16.4.10.2.1.1.14 integer read-only
Block size of the datafile.
                                     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.
                                     oramodCfgDfRECOVER 1.3.6.1.4.1.546.16.4.10.2.1.1.16 displaystring read-only
YES/NO File needs media recovery.
                                     oramodCfgDfRSTLOGSCHGNUM 1.3.6.1.4.1.546.16.4.10.2.1.1.17 integer read-only
Reset Logs change number.
                                     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 no-access
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 no-access
An entry in the Oracle Logfile table.
                                     oramodCfgLfSIDINDX 1.3.6.1.4.1.546.16.4.10.3.1.1.1 integer read-only
Sid Index Number.
                                     oramodCfgLfMEMBERINDX 1.3.6.1.4.1.546.16.4.10.3.1.1.2 integer read-only
Logfile member index.
                                     oramodCfgLfGROUPNUM 1.3.6.1.4.1.546.16.4.10.3.1.1.3 integer read-only
Group Number.
                                     oramodCfgLfSTATUS 1.3.6.1.4.1.546.16.4.10.3.1.1.4 displaystring read-only
Status of File.
                                     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 no-access
This table summarizes the system global area.
                                 oramodCfgSgaEntry 1.3.6.1.4.1.546.16.4.10.4.1.1 no-access
An entry in the Oracle Sga table.
                                     oramodCfgSgaSIDINDX 1.3.6.1.4.1.546.16.4.10.4.1.1.1 integer read-only
Sid Index Number.
                                     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.
                                     oramodCfgSgaFIXEDSGA 1.3.6.1.4.1.546.16.4.10.4.1.1.3 integer read-only
Fixed memory allocated in Kbytes
                                     oramodCfgSgaVARIABLE 1.3.6.1.4.1.546.16.4.10.4.1.1.4 integer read-only
Variable Memory allocated in the SGA
                                     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.
                                     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 no-access
This table describes the system footprint.
                                     oramodFootprtEntry 1.3.6.1.4.1.546.16.4.11.1.1.1.1 no-access
An entry in the Oracle Footprint table.
                                         oramodFootprtSIDINDX 1.3.6.1.4.1.546.16.4.11.1.1.1.1.1 integer read-only
Empire's Index Number.
                                         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.
                                         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'
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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).
                                         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.
                                         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.
                                         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.
                                         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 no-access
This table describes the system footprint.
                                     oramodFFootprtEntry 1.3.6.1.4.1.546.16.4.11.1.2.1.1 no-access
An entry in the Oracle File Footprint table.
                                         oramodFFootprtSIDINDX 1.3.6.1.4.1.546.16.4.11.1.2.1.1.1 integer read-only
Sid Index Number.
                                         oramodFFootprtFILEINDX 1.3.6.1.4.1.546.16.4.11.1.2.1.1.2 integer read-only
File Index Number.
                                         oramodFFootprtFILETYPE 1.3.6.1.4.1.546.16.4.11.1.2.1.1.3 displaystring read-only
File Type.
                                         oramodFFootprtFILENAME 1.3.6.1.4.1.546.16.4.11.1.2.1.1.4 displaystring read-only
File Name.
                                         oramodFFootprtCRTTS 1.3.6.1.4.1.546.16.4.11.1.2.1.1.5 displaystring read-only
Last update timestamp.
                                         oramodFFootprtCRTKBYTES 1.3.6.1.4.1.546.16.4.11.1.2.1.1.6 integer read-only
File creation kbytes.
                                         oramodFFootprtKBYTES 1.3.6.1.4.1.546.16.4.11.1.2.1.1.7 integer read-only
File kbytes.
                                         oramodFFootprtBLOCKS 1.3.6.1.4.1.546.16.4.11.1.2.1.1.8 integer read-only
File blocks.
                                         oramodFFootprtSTATUS 1.3.6.1.4.1.546.16.4.11.1.2.1.1.9 displaystring read-only
File Status.
                                         oramodFFootprtRECOVER 1.3.6.1.4.1.546.16.4.11.1.2.1.1.10 displaystring read-only
Last Recover timestamp.
                                         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 no-access
This table describes the database metrics.
                                 oramodMetricsEntry 1.3.6.1.4.1.546.16.4.11.2.1.1 no-access
An entry in the Metrics table.
                                     oramodMetricsSIDINDX 1.3.6.1.4.1.546.16.4.11.2.1.1.1 integer read-only
Sid Index Number.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     oramodMetricsSESSCURRENT 1.3.6.1.4.1.546.16.4.11.2.1.1.34 gauge read-only
The current number of sessions.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     oramodMetricsARCHIVER 1.3.6.1.4.1.546.16.4.11.2.1.1.47 displaystring read-only
The database archiver.
                                     oramodMetricsDATABASESTATUS 1.3.6.1.4.1.546.16.4.11.2.1.1.48 displaystring read-only
The status of the database.
                                     oramodMetricsSHUTDOWNPENDING 1.3.6.1.4.1.546.16.4.11.2.1.1.49 displaystring read-only
The shutdown status of the database.
                                     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 no-access
This table describes the data dictionary aggregates.
                                     oramodSgaDddAggEntry 1.3.6.1.4.1.546.16.4.11.3.1.1.1 no-access
An entry in the Data Dictionary Aggregate table.
                                         oramodSGAAGGSIDINDX 1.3.6.1.4.1.546.16.4.11.3.1.1.1.1 integer read-only
Sid Index Number.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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 no-access
This table describes the detailed library cache information.
                                     oramodSgaDlciEntry 1.3.6.1.4.1.546.16.4.11.3.2.1.1 no-access
An entry in the Library Cache table.
                                         oramodSGADLCISIDINDX 1.3.6.1.4.1.546.16.4.11.3.2.1.1.1 integer read-only
Sid Index Number.
                                         oramodSGADLCIINDX 1.3.6.1.4.1.546.16.4.11.3.2.1.1.2 integer read-only
Namespace Index Number.
                                         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)
                                         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).
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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.
                                         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 no-access
This table describes the Redo Log information.
                                 oramodRedoLogBufEntry 1.3.6.1.4.1.546.16.4.11.4.1.1 no-access
An entry in the Redo Log table.
                                     oramodREDOSIDINDX 1.3.6.1.4.1.546.16.4.11.4.1.1.1 integer read-only
Sid Index Number.
                                     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.
                                     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.
                                     oramodREDOSIZE 1.3.6.1.4.1.546.16.4.11.4.1.1.4 integer read-only
The size of the redo log.
                                     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.
                                     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
                                     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.
                                     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.
                                     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.
                                     oramodREDORETRIES 1.3.6.1.4.1.546.16.4.11.4.1.1.10 counter read-only
The total number of redo retries.
                                     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 no-access
This table describes any rollback segments.
                                 oramodRollBackEntry 1.3.6.1.4.1.546.16.4.11.5.1.1 no-access
An entry in the rollstat table.
                                     oramodRollBackSIDINDX 1.3.6.1.4.1.546.16.4.11.5.1.1.1 integer read-only
SID Index Number.
                                     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.
                                     oramodRollBackSEGNAME 1.3.6.1.4.1.546.16.4.11.5.1.1.3 displaystring read-only
Rollback Segment Name.
                                     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.
                                     oramodRollBackRSSIZE 1.3.6.1.4.1.546.16.4.11.5.1.1.5 counter read-only
The size of the Rollback Segment.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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.
                                     oramodRollBackAVEACTIVE 1.3.6.1.4.1.546.16.4.11.5.1.1.14 counter read-only
Segment average active.
                                     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 no-access
This table describes resource waits.
                                 oramodWaitsEntry 1.3.6.1.4.1.546.16.4.11.6.1.1 no-access
An entry in the waits table.
                                     oramodWaitsSIDINDX 1.3.6.1.4.1.546.16.4.11.6.1.1.1 integer read-only
Sid Index Number.
                                     oramodWaitsEVENTINDX 1.3.6.1.4.1.546.16.4.11.6.1.1.2 integer read-only
Event's Index Number.
                                     oramodWaitsEVENT 1.3.6.1.4.1.546.16.4.11.6.1.1.3 displaystring read-only
Resource Name.
                                     oramodWaitsTOTALWAITS 1.3.6.1.4.1.546.16.4.11.6.1.1.4 counter read-only
Resource Total Waits.
                                     oramodWaitsTOTALTIMOUT 1.3.6.1.4.1.546.16.4.11.6.1.1.5 counter read-only
Resource Total Timeouts.
                                     oramodWaitsTIMEWAITED 1.3.6.1.4.1.546.16.4.11.6.1.1.6 counter read-only
Resource Total Waited.
                                     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 no-access
This table describes expensive sql.
                                 oramodExpSqlEntry 1.3.6.1.4.1.546.16.4.11.7.1.1 no-access
An entry in the v$sqlarea table.
                                     oramodExpSqlSIDINDX 1.3.6.1.4.1.546.16.4.11.7.1.1.1 integer read-only
Sid Index Number.
                                     oramodExpSqlSQLINDX 1.3.6.1.4.1.546.16.4.11.7.1.1.2 integer read-only
SQL Statement Index Number.
                                     oramodExpSqlEXECUTION 1.3.6.1.4.1.546.16.4.11.7.1.1.3 gauge read-only
Number of Executions.
                                     oramodExpSqlDISKREAD 1.3.6.1.4.1.546.16.4.11.7.1.1.4 gauge read-only
Number of Disk Reads.
                                     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.
                                     oramodExpSqlBUFFGETS 1.3.6.1.4.1.546.16.4.11.7.1.1.6 gauge read-only
Number of Buffer Gets.
                                     oramodExpSqlSORTS 1.3.6.1.4.1.546.16.4.11.7.1.1.7 gauge read-only
Number of Sorts.
                                     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 no-access
List Fragmentation Information.
                                 oramodTblspEntry 1.3.6.1.4.1.546.16.4.11.8.1.1 no-access
An entry from the dbafreespace table.
                                     oramodTblspSIDINDX 1.3.6.1.4.1.546.16.4.11.8.1.1.1 integer read-only
Sid Index Number.
                                     oramodTblspTBLSPINDX 1.3.6.1.4.1.546.16.4.11.8.1.1.2 integer read-only
Tablespace Index Number.
                                     oramodTblspTBLSPNAME 1.3.6.1.4.1.546.16.4.11.8.1.1.3 displaystring read-only
Tablespace Name.
                                     oramodTblspFILENAME 1.3.6.1.4.1.546.16.4.11.8.1.1.4 displaystring read-only
File Name.
                                     oramodTblspEXTENTS 1.3.6.1.4.1.546.16.4.11.8.1.1.5 gauge read-only
The number of extents.
                                     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.
                                     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.
                                     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.
                                     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.
                                     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 no-access
Lock Holders and Requestors
                                     oramodLockEntry 1.3.6.1.4.1.546.16.4.11.9.1.1.1 no-access
An entry from the lock and session tables.
                                         oramodLockSIDINDX 1.3.6.1.4.1.546.16.4.11.9.1.1.1.1 integer read-only
Sid Index Number.
                                         oramodLockUSERINDX 1.3.6.1.4.1.546.16.4.11.9.1.1.1.2 integer read-only
User's Index Number.
                                         oramodLockUSERNAME 1.3.6.1.4.1.546.16.4.11.9.1.1.1.3 displaystring read-only
User Name holding the lock.
                                         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.
                                         oramodLockTYPE 1.3.6.1.4.1.546.16.4.11.9.1.1.1.5 displaystring read-only
Object Type.
                                         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).
                                         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.
                                         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 no-access
Latch information.
                                     oramodLatchEntry 1.3.6.1.4.1.546.16.4.11.9.2.1.1 no-access
An entry from the latch table.
                                         oramodLatchSIDINDX 1.3.6.1.4.1.546.16.4.11.9.2.1.1.1 integer read-only
Sid Index Number.
                                         oramodLatchLATCHINDX 1.3.6.1.4.1.546.16.4.11.9.2.1.1.2 integer read-only
Latch Index Number.
                                         oramodLatchLATCHNUM 1.3.6.1.4.1.546.16.4.11.9.2.1.1.3 integer read-only
Latch Number.
                                         oramodLatchLATCHNAME 1.3.6.1.4.1.546.16.4.11.9.2.1.1.4 displaystring read-only
Latch Name.
                                         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.
                                         oramodLatchMISSES 1.3.6.1.4.1.546.16.4.11.9.2.1.1.6 counter read-only
Latch Misses.
                                         oramodLatchSLEEPS 1.3.6.1.4.1.546.16.4.11.9.2.1.1.7 counter read-only
Latch Sleeps.
                                         oramodLatchIMDGETS 1.3.6.1.4.1.546.16.4.11.9.2.1.1.8 counter read-only
Latch Immediate Gets.
                                         oramodLatchIMDMISSES 1.3.6.1.4.1.546.16.4.11.9.2.1.1.9 counter read-only
Latch Immediate Misses.
                                         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.
                                         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 no-access
Backup Information
                                       oramodBackupEntry 1.3.6.1.4.1.546.16.4.11.10.1.1.1 no-access
An entry from the backup table.
                                           oramodBackupSIDINDX 1.3.6.1.4.1.546.16.4.11.10.1.1.1.1 integer read-only
Sid Index Number.
                                           oramodBackupFILENUM 1.3.6.1.4.1.546.16.4.11.10.1.1.1.2 integer read-only
Backup File Index Number.
                                           oramodBackupSTATUS 1.3.6.1.4.1.546.16.4.11.10.1.1.1.3 displaystring read-only
Status of the backup.
                                           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.
                                           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 no-access
Archive Information.
                                       oramodArcDestEntry 1.3.6.1.4.1.546.16.4.11.11.1.1.1 no-access
An entry from the archive destination table.
                                           oramodArcDestSIDINDX 1.3.6.1.4.1.546.16.4.11.11.1.1.1.1 integer read-only
Sid Index Number.
                                           oramodArcDestARCINDX 1.3.6.1.4.1.546.16.4.11.11.1.1.1.2 integer read-only
Index of Archive log.
                                           oramodArcDestARCMODE 1.3.6.1.4.1.546.16.4.11.11.1.1.1.3 displaystring read-only
Mode of Archive log.
                                           oramodArcDestSTATUS 1.3.6.1.4.1.546.16.4.11.11.1.1.1.4 displaystring read-only
Status of Archive Log File.
                                           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
                         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.
                         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'
                         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.
                         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.
                         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.
                         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.
                         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.
                         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.
                         oramodTtlMSGSSENT 1.3.6.1.4.1.546.16.4.12.9 counter read-only
The number of messages sent by the processes.
                         oramodTtlMSGSRCVD 1.3.6.1.4.1.546.16.4.12.10 counter read-only
The number of messages received by the processes.
                         oramodTtlSYSCALLS 1.3.6.1.4.1.546.16.4.12.11 counter read-only
The number of system calls invoked by the processes.
                         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.
                         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.
                         oramodTtlNUMSWAPS 1.3.6.1.4.1.546.16.4.12.14 counter read-only
The number of times the processes have been swapped.
                         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).
                         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.
                         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.