EMPIRE-ORAMOD
325 objects
No module-level DESCRIPTION found.
Imported Objects
| RFC-1212 | OBJECT-TYPE |
| RFC-1215 | TRAP-TYPE |
| RFC1155-SMI | Counter enterprises Gauge TimeTicks |
| RFC1213-MIB | DisplayString |
| OID | Name | Access | Status | Description |
|---|---|---|---|---|
| 1.3.6.1.4.1.546 | Nodeempire | |||
| 1.3.6.1.4.1.546.16 | Nodeapplications | |||
| 1.3.6.1.4.1.546.16.4 | Nodeoracledb | |||
| 1.3.6.1.4.1.546.16.4.1 | ScalaroraModVersion | read-only | mandatory | Description and version number of this installation. |
| 1.3.6.1.4.1.546.16.4.2 | ScalaroraModMode | read-only | mandatory | 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 vali… |
| 1.3.6.1.4.1.546.16.4.3 | ScalaroraFlag | read-only | mandatory | Performance flags for this installation. |
| 1.3.6.1.4.1.546.16.4.10 | NodeoramodCfg | |||
| 1.3.6.1.4.1.546.16.4.10.1 | NodeoramodDbCfg | |||
| 1.3.6.1.4.1.546.16.4.10.1.1 | TableoramodDbCfgTable | not-accessible | mandatory | This table describes the instance names, index numbers and initial startup information. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1 | RoworamodDbCfgEntry | not-accessible | mandatory | An entry in the Oracle Configuration table. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.1 | ColumnoramodDbCfgSIDINDX | read-only | mandatory | Sid's Index Number. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.2 | ColumnoramodDbCfgSID | read-only | mandatory | Database Name. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.3 | ColumnoramodDbCfgVERSION | read-only | mandatory | Description and version of this Oracle installation from v$version |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.4 | ColumnoramodDbCfgHOME | read-only | mandatory | The Installation Directory for Oracle or ORACLEHOME. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.5 | ColumnoramodDbCfgBASE | read-only | mandatory | The Base Directory for Oracle or ORACLEBASE. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.6 | ColumnoramodDbCfgID | read-only | mandatory | The database ID calculated when the database is created and stored in all file headers (521382036). |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.7 | ColumnoramodDbCfgCRTDT | read-only | mandatory | The original creation date and time of the database. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.8 | ColumnoramodDbCfgLOGMODE | read-only | mandatory | The Archive log mode: NOARCHIVELOG or ARCHIVELOG. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.9 | ColumnoramodDbCfgCTRLFILETYPE | read-only | mandatory | Control File Type. Can be the following types : CURRENT,STANDBY,CLONE,BACKUP,CREATED. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.10 | ColumnoramodDbCfgOPENMODE | read-only | mandatory | Shows whether the database is set to READ WRITE or READ ONLY (NEW TO 8i.). |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.11 | ColumnoramodDbCfgMAXPROCESS | read-only | mandatory | For a multiple-process operation, this parameter specifies the maximum number of user processes that can simultaneously connect to an Oracle server. The PROCES… |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.12 | ColumnoramodDbCfgMAXSESSION | read-only | mandatory | Maximum number of User and System Sessions. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.13 | ColumnoramodDbCfgTIMEDSTATISTICS | read-only | mandatory | TRUE/FALSE: sets timing on. Should be false for maximum performance. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.14 | ColumnoramodDbCfgCPUCNT | read-only | mandatory | The maximum number of CPU's for this instance. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.15 | ColumnoramodDbCfgSHAREDPOOLSIZE | read-only | mandatory | 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 3… |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.16 | ColumnoramodDbCfgSHAREDPOOLRSSIZE | read-only | mandatory | Shared Pool Reserved Size Kbytes. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.17 | ColumnoramodDbCfgLARGEPOOLSIZE | read-only | mandatory | Large Pool Reserved Size Kbytes. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.18 | ColumnoramodDbCfgJAVAPOOLSIZE | read-only | mandatory | Java Pool Size in Kbytes Default is (20000K) |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.19 | ColumnoramodDbCfgCNTRLFILES | read-only | mandatory | Name and path of control files. String of file names. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.20 | ColumnoramodDbCfgDBBLKBUFF | read-only | mandatory | Number of Database Block Buffers in blocks. Controls how much memory is available in the buffer cache for data blocks. Default is (26240) |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.21 | ColumnoramodDbCfgDBBLKSIZE | read-only | mandatory | Size of Database Blocks. O/S dependent |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.22 | ColumnoramodDbCfgCKPTINTRVL | read-only | mandatory | Redo Log Checkpoint Interval. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.23 | ColumnoramodDbCfgDBFILES | read-only | mandatory | Maximum Number of Database Files. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.24 | ColumnoramodDbCfgSORTAREASIZE | read-only | mandatory | 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 t… |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.25 | ColumnoramodDbCfgOPENCURSORS | read-only | mandatory | Maximum open cursors a single-user process can have at once. Typical Range (1 - 2147483647). |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.26 | ColumnoramodDbCfgTRNSACTNS | read-only | mandatory | Maximum number of concurrent transactions allowed at one time. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.27 | ColumnoramodDbCfgTRNSACTNSPERSEG | read-only | mandatory | Maximum number of concurrent transactions per segment. Default is 30. O/S dependent. |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.28 | ColumnoramodDbCfgMAXROLLSEG | read-only | mandatory | Maximum number of rollback segments. |
| 1.3.6.1.4.1.546.16.4.10.2 | NodeoramodCfgDf | |||
| 1.3.6.1.4.1.546.16.4.10.2.1 | TableoramodCfgDfTable | not-accessible | mandatory | This table describes the database files for the database. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1 | RoworamodCfgDfEntry | not-accessible | mandatory | An entry in the Oracle v$datafile table. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.1 | ColumnoramodCfgDfSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.2 | ColumnoramodCfgDfFILENUM | read-only | mandatory | File Identification Number. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.3 | ColumnoramodCfgDfSTATUS | read-only | mandatory | Type of file (system or user) and its status. Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF(an offline file from the SYSTEM tablespace). |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.4 | ColumnoramodCfgDfENABLED | read-only | mandatory | Describes how accessible the file is from SQL. Can be DISABLED, READ ONLY, READ WRITE and UNKNOWN. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.5 | ColumnoramodCfgDfUNRCVRBLECHG | read-only | mandatory | The last unrecoverbale change number made to this datafile. Always updated when an unrecoverable operation completes. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.6 | ColumnoramodCfgDfUNRCVRBLETIME | read-only | mandatory | The last unrecoverbale change time made to this datafile. Always updated when an unrecoverable operation completes. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.7 | ColumnoramodCfgDfKBYTES | read-only | mandatory | Current size in kbytes; 0 if unaccessible. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.8 | ColumnoramodCfgDfCRTKBYTES | read-only | mandatory | Size when created. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.9 | ColumnoramodCfgDfFNAME | read-only | mandatory | Name of the file. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.10 | ColumnoramodCfgDfCRTTIME | read-only | mandatory | Time at which the datafile was created. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.11 | ColumnoramodCfgDfTBLESPACENUM | read-only | mandatory | Tablespace Number. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.12 | ColumnoramodCfgDfTBLESPACERFILENUM | read-only | mandatory | Tablespace Relative Df Number. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.13 | ColumnoramodCfgDfBLOCKS | read-only | mandatory | Current datafile size in blocks; 0 if inaccessible. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.14 | ColumnoramodCfgDfBLOCKSIZE | read-only | mandatory | Block size of the datafile. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.15 | ColumnoramodCfgDfERROR | read-only | mandatory | NULL if the header read success. If error must restore. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.16 | ColumnoramodCfgDfRECOVER | read-only | mandatory | YES/NO File needs media recovery. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.17 | ColumnoramodCfgDfRSTLOGSCHGNUM | read-only | mandatory | Reset Logs change number. |
| 1.3.6.1.4.1.546.16.4.10.2.1.1.18 | ColumnoramodCfgDfRSTLOGSTIME | read-only | mandatory | Reset Logs timestamp. |
| 1.3.6.1.4.1.546.16.4.10.3 | NodeoramodCfgLf | |||
| 1.3.6.1.4.1.546.16.4.10.3.1 | TableoramodCfgLfTable | not-accessible | mandatory | This table describes the redo log files locations for each Oracle installation from v$logfile. |
| 1.3.6.1.4.1.546.16.4.10.3.1.1 | RoworamodCfgLfEntry | not-accessible | mandatory | An entry in the Oracle Logfile table. |
| 1.3.6.1.4.1.546.16.4.10.3.1.1.1 | ColumnoramodCfgLfSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.10.3.1.1.2 | ColumnoramodCfgLfMEMBERINDX | read-only | mandatory | Logfile member index. |
| 1.3.6.1.4.1.546.16.4.10.3.1.1.3 | ColumnoramodCfgLfGROUPNUM | read-only | mandatory | Group Number. |
| 1.3.6.1.4.1.546.16.4.10.3.1.1.4 | ColumnoramodCfgLfSTATUS | read-only | mandatory | Status of File. |
| 1.3.6.1.4.1.546.16.4.10.3.1.1.5 | ColumnoramodCfgLfMEMBER | read-only | mandatory | File name and path. |
| 1.3.6.1.4.1.546.16.4.10.4 | NodeoramodCfgSga | |||
| 1.3.6.1.4.1.546.16.4.10.4.1 | TableoramodCfgSgaTable | not-accessible | mandatory | This table summarizes the system global area. |
| 1.3.6.1.4.1.546.16.4.10.4.1.1 | RoworamodCfgSgaEntry | not-accessible | mandatory | An entry in the Oracle Sga table. |
| 1.3.6.1.4.1.546.16.4.10.4.1.1.1 | ColumnoramodCfgSgaSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.10.4.1.1.2 | ColumnoramodCfgSgaTOTALMEMALLOC | read-only | mandatory | Total real memory allocated. Summation of values in v$sga. |
| 1.3.6.1.4.1.546.16.4.10.4.1.1.3 | ColumnoramodCfgSgaFIXEDSGA | read-only | mandatory | Fixed memory allocated in Kbytes |
| 1.3.6.1.4.1.546.16.4.10.4.1.1.4 | ColumnoramodCfgSgaVARIABLE | read-only | mandatory | Variable Memory allocated in the SGA |
| 1.3.6.1.4.1.546.16.4.10.4.1.1.5 | ColumnoramodCfgSgaDBBUFF | read-only | mandatory | Database buffers allocated in Kbytes. Typical Range is 4 Kbytes - 2 Gbytes. |
| 1.3.6.1.4.1.546.16.4.10.4.1.1.6 | ColumnoramodCfgSgaREDOBUFF | read-only | mandatory | Redo Buffers allocated in Kbytes |
| 1.3.6.1.4.1.546.16.4.11 | NodeoramodPerf | |||
| 1.3.6.1.4.1.546.16.4.11.1 | NodeoramodFootprint | |||
| 1.3.6.1.4.1.546.16.4.11.1.1 | NodeoramodFootprt | |||
| 1.3.6.1.4.1.546.16.4.11.1.1.1 | TableoramodFootprtTable | not-accessible | mandatory | This table describes the system footprint. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1 | RoworamodFootprtEntry | not-accessible | mandatory | An entry in the Oracle Footprint table. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.1 | ColumnoramodFootprtSIDINDX | read-only | mandatory | Empire's Index Number. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.2 | ColumnoramodFootprtCPUTIME | read-only | mandatory | 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 t… |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.3 | ColumnoramodFootprtPERCENTCPU | read-only | mandatory | 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 mu… |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.4 | ColumnoramodFootprtMEMSIZE | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.5 | ColumnoramodFootprtRSS | read-only | mandatory | 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. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.6 | ColumnoramodFootprtPERCENTMEM | read-only | mandatory | The percentage (0-100) of real memory used by the Oracle Application which includes core services and optional connectors. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.7 | ColumnoramodFootprtTHREADS | read-only | mandatory | 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 p… |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.8 | ColumnoramodFootprtINBLKS | read-only | mandatory | The number of blocks of data input by the processes. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.9 | ColumnoramodFootprtOUTBLKS | read-only | mandatory | The number of blocks of data put by the processes. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.10 | ColumnoramodFootprtMSGSSENT | read-only | mandatory | The number of messages sent by the processes. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.11 | ColumnoramodFootprtMSGSRCVD | read-only | mandatory | The number of messages received by the processes. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.12 | ColumnoramodFootprtSYSCALLS | read-only | mandatory | The number of system calls invoked by the processes. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.13 | ColumnoramodFootprtMINORPGFLTS | read-only | mandatory | The number of minor page faults incurred by the process. Minor faults do not require I/O to retrieve the page. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.14 | ColumnoramodFootprtMAJORPGFLTS | read-only | mandatory | The number of major page faults incurred by the process. Minor faults require I/O to retrieve the page. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.15 | ColumnoramodFootprtNUMSWAPS | read-only | mandatory | The number of times the processes have been swapped. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.16 | ColumnoramodFootprtVOLCNTX | read-only | mandatory | The number of voluntary context switches incurred by the processes. Voluntary contest switches occur when the processor voluntary gives up the CPU (e.g. waitin… |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.17 | ColumnoramodFootprtINVOLCNTX | read-only | mandatory | The number of involuntary context switches incurred by the processes. An involuntary context switch occurs when the process has executed for the duration of it… |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.18 | ColumnoramodFootprtHOMESIZE | read-only | mandatory | The size, in KBytes of the Oracle root directory and all files beneath it. |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.19 | ColumnoramodFootprtDBDISKSIZE | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.11.1.1.1.1.20 | ColumnoramodFootprtLASTUPDATE | read-only | mandatory | The time (based on sysUpTime) that the last update of all variables in the table was completed. |
| 1.3.6.1.4.1.546.16.4.11.1.2 | NodeoramodFFootprt | |||
| 1.3.6.1.4.1.546.16.4.11.1.2.1 | TableoramodFFootprtTable | not-accessible | mandatory | This table describes the system footprint. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1 | RoworamodFFootprtEntry | not-accessible | mandatory | An entry in the Oracle File Footprint table. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.1 | ColumnoramodFFootprtSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.2 | ColumnoramodFFootprtFILEINDX | read-only | mandatory | File Index Number. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.3 | ColumnoramodFFootprtFILETYPE | read-only | mandatory | File Type. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.4 | ColumnoramodFFootprtFILENAME | read-only | mandatory | File Name. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.5 | ColumnoramodFFootprtCRTTS | read-only | mandatory | Last update timestamp. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.6 | ColumnoramodFFootprtCRTKBYTES | read-only | mandatory | File creation kbytes. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.7 | ColumnoramodFFootprtKBYTES | read-only | mandatory | File kbytes. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.8 | ColumnoramodFFootprtBLOCKS | read-only | mandatory | File blocks. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.9 | ColumnoramodFFootprtSTATUS | read-only | mandatory | File Status. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.10 | ColumnoramodFFootprtRECOVER | read-only | mandatory | Last Recover timestamp. |
| 1.3.6.1.4.1.546.16.4.11.1.2.1.1.11 | ColumnoramodFFootprtAVGIOTIM | read-only | mandatory | File average I/O time. |
| 1.3.6.1.4.1.546.16.4.11.2 | NodeoramodMetrics | |||
| 1.3.6.1.4.1.546.16.4.11.2.1 | TableoramodMetricsTable | not-accessible | mandatory | This table describes the database metrics. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1 | RoworamodMetricsEntry | not-accessible | mandatory | An entry in the Metrics table. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.1 | ColumnoramodMetricsSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.2 | ColumnoramodMetricsBCPT | read-only | mandatory | Block Changes Per Transaction scaled by 100. This ratio measures the amount of DML work that each transaction performs. Creating or dropping indexes impact thi… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.3 | ColumnoramodMetricsBGR | read-only | mandatory | 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 sy… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.4 | ColumnoramodMetricsBVPT | read-only | mandatory | 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 wor… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.5 | ColumnoramodMetricsCHR | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.6 | ColumnoramodMetricsCR | read-only | mandatory | 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 sour… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.7 | ColumnoramodMetricsCPT | read-only | mandatory | 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… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.8 | ColumnoramodMetricsCBR | read-only | mandatory | Changed Blocks scaled by 100. Measures the balance between queris and data manipulation language (DML) within the database applications. Can be used to detect … |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.9 | ColumnoramodMetricsCCR | read-only | mandatory | 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… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.10 | ColumnoramodMetricsCRR | read-only | mandatory | 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 thi… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.11 | ColumnoramodMetricsLCM | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.12 | ColumnoramodMetricsRTUC | read-only | mandatory | 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 t… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.13 | ColumnoramodMetricsRLSW | read-only | mandatory | 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 alloca… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.14 | ColumnoramodMetricsRSR | read-only | mandatory | 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, … |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.15 | ColumnoramodMetricsSOR | read-only | mandatory | Sort Overflow Ratio scaled by 100. Indicates the number of sorts which are using temporary segments. Under restrictive circumstances when there is a predominan… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.16 | ColumnoramodMetricsTRR | read-only | mandatory | 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… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.17 | ColumnoramodMetricsUCR | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.18 | ColumnoramodMetricsUCPP | read-only | mandatory | 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 a… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.19 | ColumnoramodMetricsURR | read-only | mandatory | User Rollback Ratio scaled by 100. The ratio of user or application transaction rollbacks. Indicates the rate at which application transactions are failing. Ro… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.20 | ColumnoramodMetricsSGALCE | read-only | mandatory | 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.… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.21 | ColumnoramodMetricsSGADDCE | read-only | mandatory | 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… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.22 | ColumnoramodMetricsDBTOTALRW | read-only | mandatory | The total number of physical reads and physical writes since instance startup. See individual descriptions below. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.23 | ColumnoramodMetricsDBBLKCHG | read-only | mandatory | 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 i… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.24 | ColumnoramodMetricsDBBLKGET | read-only | mandatory | 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, r… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.25 | ColumnoramodMetricsDBCNSTGET | read-only | mandatory | 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 databas… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.26 | ColumnoramodMetricsDBPHYSREAD | read-only | mandatory | 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 equa… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.27 | ColumnoramodMetricsDBSORTDISK | read-only | mandatory | 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. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.28 | ColumnoramodMetricsDBSORTMEM | read-only | mandatory | 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 in… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.29 | ColumnoramodMetricsBLKFREEWAIT | read-only | mandatory | 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 recreate… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.30 | ColumnoramodMetricsMTHRDQUEUEWAIT | read-only | mandatory | The number of seconds waited in queue for multi-threaded servers. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.31 | ColumnoramodMetricsSESSHIWTRMEM | read-only | mandatory | The maximum highwater amount of session memory used. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.32 | ColumnoramodMetricsSESSCURRMEM | read-only | mandatory | The current maximum amount of session memory used. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.33 | ColumnoramodMetricsSESSHIWTR | read-only | mandatory | The highwater mark for number of sessions. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.34 | ColumnoramodMetricsSESSCURRENT | read-only | mandatory | The current number of sessions. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.35 | ColumnoramodMetricsUSERCOMMITS | read-only | mandatory | Records the number of database transactions successfully completed and records the number of aborted database transactions. In most real world applications, th… |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.36 | ColumnoramodMetricsUSERROLLBACK | read-only | mandatory | The number of transactions rolled back since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.37 | ColumnoramodMetricsUSERCALLS | read-only | mandatory | The number of transactions started since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.38 | ColumnoramodMetricsDBPHYSWRTS | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.39 | ColumnoramodMetricsTBLSCANROWS | read-only | mandatory | The number of rows retrieved through table scans since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.40 | ColumnoramodMetricsTBLFTCHROWID | read-only | mandatory | The number of rows retrieved through table fetches by rowid since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.41 | ColumnoramodMetricsTBLFTCHCROW | read-only | mandatory | The number of rows retrieved through table fetches by continued row since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.42 | ColumnoramodMetricsRECRSVCALLS | read-only | mandatory | The number of recursive calls since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.43 | ColumnoramodMetricsCNSTCHGS | read-only | mandatory | The number of consistent changes since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.44 | ColumnoramodMetricsPARSECNT | read-only | mandatory | The number of parses since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.45 | ColumnoramodMetricsCPUTM | read-only | mandatory | The amount of time taken to work requests. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.46 | ColumnoramodMetricsLOGFILESWTCH | read-only | mandatory | The number of redo log file switches. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.47 | ColumnoramodMetricsARCHIVER | read-only | mandatory | The database archiver. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.48 | ColumnoramodMetricsDATABASESTATUS | read-only | mandatory | The status of the database. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.49 | ColumnoramodMetricsSHUTDOWNPENDING | read-only | mandatory | The shutdown status of the database. |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.50 | ColumnoramodMetricsLASTUPDATE | read-only | mandatory | The time (based on sysUpTime) that the last update of all variables in the table was completed. |
| 1.3.6.1.4.1.546.16.4.11.3 | NodeoramodSGA | |||
| 1.3.6.1.4.1.546.16.4.11.3.1 | NodeoramodSgaDddAgg | |||
| 1.3.6.1.4.1.546.16.4.11.3.1.1 | TableoramodSgaDddAggTable | not-accessible | mandatory | This table describes the data dictionary aggregates. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1 | RoworamodSgaDddAggEntry | not-accessible | mandatory | An entry in the Data Dictionary Aggregate table. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.1 | ColumnoramodSGAAGGSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.2 | ColumnoramodSGAAGGCNT | read-only | mandatory | Total number of entries in the data dictionary cache since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.3 | ColumnoramodSGAAGGUSGE | read-only | mandatory | The total number of cache entries with valid data since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.4 | ColumnoramodSGAAGGFIX | read-only | mandatory | The total number of fixed entries in the data dictionary cache since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.5 | ColumnoramodSGAAGGGET | read-only | mandatory | The total number of information requests since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.6 | ColumnoramodSGAAGGGETMISS | read-only | mandatory | The total number of informations requests resulting in cache misses since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.7 | ColumnoramodSGAAGGSCAN | read-only | mandatory | The total number of scan requests since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.8 | ColumnoramodSGAAGGSCANMISS | read-only | mandatory | The total number of scan requests resulting in misses since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.9 | ColumnoramodSGAAGGSCANCPLT | read-only | mandatory | For subordinate entries, the total number of times list was scanned completely since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.10 | ColumnoramodSGAAGGMODS | read-only | mandatory | The total number of inserts, updates, and deletions since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.1.1.1.11 | ColumnoramodSGAAGGFLUSH | read-only | mandatory | The total number of times flushed to disk since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.2 | NodeoramodSgaDlci | |||
| 1.3.6.1.4.1.546.16.4.11.3.2.1 | TableoramodSgaDlciTable | not-accessible | mandatory | This table describes the detailed library cache information. |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1 | RoworamodSgaDlciEntry | not-accessible | mandatory | An entry in the Library Cache table. |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.1 | ColumnoramodSGADLCISIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.2 | ColumnoramodSGADLCIINDX | read-only | mandatory | Namespace Index Number. |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.3 | ColumnoramodSGADLCINAME | read-only | mandatory | Library Cache Namespace. (SQL AREA, TABLE/PROCEDURE, BODY, TRIGGER, INDEX, CLUSTER, OBJECT, PIPE) |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.4 | ColumnoramodSGADLCIGET | read-only | mandatory | The total number of request handles to library namespace since instance startup Typical range (0..500,00). |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.5 | ColumnoramodSGADLCIGETHIT | read-only | mandatory | The total number of times handles are already allocated in the cache. If the handle is not already allocated it is a miss. |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.6 | ColumnoramodSGADLCIGETHITRT | read-only | mandatory | 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 hig… |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.7 | ColumnoramodSGADLCIPIN | read-only | mandatory | The total number of pin requests for objects in the cache since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.8 | ColumnoramodSGADLCIPINHIT | read-only | mandatory | 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 reallocat… |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.9 | ColumnoramodSGADLCIPINHITRT | read-only | mandatory | 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. |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.10 | ColumnoramodSGADLCIRELOAD | read-only | mandatory | 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 per… |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.11 | ColumnoramodSGADLCIINVALID | read-only | mandatory | The number of times that non-persistant library objects (like SQL areas) have been invalidated. |
| 1.3.6.1.4.1.546.16.4.11.4 | NodeoramodRedoLogBuf | |||
| 1.3.6.1.4.1.546.16.4.11.4.1 | TableoramodRedoLogBufTable | not-accessible | mandatory | This table describes the Redo Log information. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1 | RoworamodRedoLogBufEntry | not-accessible | mandatory | An entry in the Redo Log table. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.1 | ColumnoramodREDOSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.2 | ColumnoramodREDOBLKWRT | read-only | mandatory | The total number of redo blocks written since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.3 | ColumnoramodREDOENTRIES | read-only | mandatory | The total number of redo entries in the redo log since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.4 | ColumnoramodREDOSIZE | read-only | mandatory | The size of the redo log. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.5 | ColumnoramodREDOSPACERQST | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.6 | ColumnoramodREDOSPACEWAIT | read-only | mandatory | The total number of redo log space wait time since instance startup |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.7 | ColumnoramodREDOSYNCHWRT | read-only | mandatory | The total number of redo synch writes since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.8 | ColumnoramodREDOSYNCHTM | read-only | mandatory | The amount of redo log synch time. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.9 | ColumnoramodREDOWASTAGE | read-only | mandatory | The total amount of redo log wastage. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.10 | ColumnoramodREDORETRIES | read-only | mandatory | The total number of redo retries. |
| 1.3.6.1.4.1.546.16.4.11.4.1.1.11 | ColumnoramodREDOLASTUPDATE | read-only | mandatory | The time (based on sysUpTime) that the last update of all variables in the table was completed. |
| 1.3.6.1.4.1.546.16.4.11.5 | NodeoramodRollBack | |||
| 1.3.6.1.4.1.546.16.4.11.5.1 | TableoramodRollBackTable | not-accessible | mandatory | This table describes any rollback segments. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1 | RoworamodRollBackEntry | not-accessible | mandatory | An entry in the rollstat table. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.1 | ColumnoramodRollBackSIDINDX | read-only | mandatory | SID Index Number. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.2 | ColumnoramodRollBackSEGINDX | read-only | mandatory | Undo Segment Number used as an index. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.3 | ColumnoramodRollBackSEGNAME | read-only | mandatory | Rollback Segment Name. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.4 | ColumnoramodRollBackEXTENTS | read-only | mandatory | The total number of Segment Extends since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.5 | ColumnoramodRollBackRSSIZE | read-only | mandatory | The size of the Rollback Segment. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.6 | ColumnoramodRollBackWRITES | read-only | mandatory | The total number of Segment Writes since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.7 | ColumnoramodRollBackGETS | read-only | mandatory | The total number of Rollback Segment Gets since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.8 | ColumnoramodRollBackWAITS | read-only | mandatory | The total number of Segment Waits since instance startup. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.9 | ColumnoramodRollBackOPTSIZE | read-only | mandatory | The Optimal Size of the Rollback Segment. This size should be set based on application usage to minimize space management issues. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.10 | ColumnoramodRollBackSHRINKS | read-only | mandatory | The total number of Rollback Segment Shrinks since instance startup. Rollback Segments shrink back to their optimal size after extends have occurred. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.11 | ColumnoramodRollBackWRAPS | read-only | mandatory | 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 ent… |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.12 | ColumnoramodRollBackEXTENDS | read-only | mandatory | Rollback Segment extends. Extensions indicate that the rollback segments are handling larger transactions than they were designed for; and if the entire rollba… |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.13 | ColumnoramodRollBackAVESHRINK | read-only | mandatory | The average shrink size of the Rollback Segment since this instance startup. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.14 | ColumnoramodRollBackAVEACTIVE | read-only | mandatory | Segment average active. |
| 1.3.6.1.4.1.546.16.4.11.5.1.1.15 | ColumnoramodRollBackSTATUS | read-only | mandatory | Segment status. |
| 1.3.6.1.4.1.546.16.4.11.6 | NodeoramodWaits | |||
| 1.3.6.1.4.1.546.16.4.11.6.1 | TableoramodWaitsTable | not-accessible | mandatory | This table describes resource waits. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1 | RoworamodWaitsEntry | not-accessible | mandatory | An entry in the waits table. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1.1 | ColumnoramodWaitsSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1.2 | ColumnoramodWaitsEVENTINDX | read-only | mandatory | Event's Index Number. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1.3 | ColumnoramodWaitsEVENT | read-only | mandatory | Resource Name. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1.4 | ColumnoramodWaitsTOTALWAITS | read-only | mandatory | Resource Total Waits. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1.5 | ColumnoramodWaitsTOTALTIMOUT | read-only | mandatory | Resource Total Timeouts. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1.6 | ColumnoramodWaitsTIMEWAITED | read-only | mandatory | Resource Total Waited. |
| 1.3.6.1.4.1.546.16.4.11.6.1.1.7 | ColumnoramodWaitsAVGWAIT | read-only | mandatory | Resource average wait. |
| 1.3.6.1.4.1.546.16.4.11.7 | NodeoramodExpSql | |||
| 1.3.6.1.4.1.546.16.4.11.7.1 | TableoramodExpSqlTable | not-accessible | mandatory | This table describes expensive sql. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1 | RoworamodExpSqlEntry | not-accessible | mandatory | An entry in the v$sqlarea table. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.1 | ColumnoramodExpSqlSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.2 | ColumnoramodExpSqlSQLINDX | read-only | mandatory | SQL Statement Index Number. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.3 | ColumnoramodExpSqlEXECUTION | read-only | mandatory | Number of Executions. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.4 | ColumnoramodExpSqlDISKREAD | read-only | mandatory | Number of Disk Reads. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.5 | ColumnoramodExpSqlPARSECNT | read-only | mandatory | 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 i… |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.6 | ColumnoramodExpSqlBUFFGETS | read-only | mandatory | Number of Buffer Gets. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.7 | ColumnoramodExpSqlSORTS | read-only | mandatory | Number of Sorts. |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.8 | ColumnoramodExpSqlSQL | read-only | mandatory | Sql Statement truncated. |
| 1.3.6.1.4.1.546.16.4.11.8 | NodeoramodTblsp | |||
| 1.3.6.1.4.1.546.16.4.11.8.1 | TableoramodTblspTable | not-accessible | mandatory | List Fragmentation Information. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1 | RoworamodTblspEntry | not-accessible | mandatory | An entry from the dbafreespace table. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.1 | ColumnoramodTblspSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.2 | ColumnoramodTblspTBLSPINDX | read-only | mandatory | Tablespace Index Number. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.3 | ColumnoramodTblspTBLSPNAME | read-only | mandatory | Tablespace Name. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.4 | ColumnoramodTblspFILENAME | read-only | mandatory | File Name. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.5 | ColumnoramodTblspEXTENTS | read-only | mandatory | The number of extents. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.6 | ColumnoramodTblspLRGEXTENT | read-only | mandatory | Size in bytes of the largest extent. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.7 | ColumnoramodTblspSMEXTENT | read-only | mandatory | Size in bytes of the smallest extent. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.8 | ColumnoramodTblspINCREMENTBY | read-only | mandatory | Size in bytes of the next extent increment. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.9 | ColumnoramodTblspBYTESCOALSD | read-only | mandatory | 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. |
| 1.3.6.1.4.1.546.16.4.11.8.1.1.10 | ColumnoramodTblspBYTESFREE | read-only | mandatory | The total number of free bytes available. |
| 1.3.6.1.4.1.546.16.4.11.9 | NodeoramodLocks | |||
| 1.3.6.1.4.1.546.16.4.11.9.1 | NodeoramodLock | |||
| 1.3.6.1.4.1.546.16.4.11.9.1.1 | TableoramodLockTable | not-accessible | mandatory | Lock Holders and Requestors |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1 | RoworamodLockEntry | not-accessible | mandatory | An entry from the lock and session tables. |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.1 | ColumnoramodLockSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.2 | ColumnoramodLockUSERINDX | read-only | mandatory | User's Index Number. |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.3 | ColumnoramodLockUSERNAME | read-only | mandatory | User Name holding the lock. |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.4 | ColumnoramodLockOBJECT | read-only | mandatory | The name of the locked object. |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.5 | ColumnoramodLockTYPE | read-only | mandatory | Object Type. |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.6 | ColumnoramodLockMODE | read-only | mandatory | Lock Mode held (Null, Row share, Row exclusive, Share, Share row exclusive, Exclusive). |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.7 | ColumnoramodLockCTIME | read-only | mandatory | Time since current mode was granted. |
| 1.3.6.1.4.1.546.16.4.11.9.1.1.1.8 | ColumnoramodLockBLOCK | read-only | mandatory | The lock is blocking another lock. |
| 1.3.6.1.4.1.546.16.4.11.9.2 | NodeoramodLatch | |||
| 1.3.6.1.4.1.546.16.4.11.9.2.1 | TableoramodLatchTable | not-accessible | mandatory | Latch information. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1 | RoworamodLatchEntry | not-accessible | mandatory | An entry from the latch table. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.1 | ColumnoramodLatchSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.2 | ColumnoramodLatchLATCHINDX | read-only | mandatory | Latch Index Number. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.3 | ColumnoramodLatchLATCHNUM | read-only | mandatory | Latch Number. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.4 | ColumnoramodLatchLATCHNAME | read-only | mandatory | Latch Name. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.5 | ColumnoramodLatchGETS | read-only | mandatory | Latch Gets. Reflects the proportion of times requests for latches are satisfied without waiting. Should be high. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.6 | ColumnoramodLatchMISSES | read-only | mandatory | Latch Misses. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.7 | ColumnoramodLatchSLEEPS | read-only | mandatory | Latch Sleeps. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.8 | ColumnoramodLatchIMDGETS | read-only | mandatory | Latch Immediate Gets. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.9 | ColumnoramodLatchIMDMISSES | read-only | mandatory | Latch Immediate Misses. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.10 | ColumnoramodLatchWAITSHOLDING | read-only | mandatory | Latch Immediate Misses. When a session cannot acquire a latch, it goes into active wait and repeatedly trys to acquire the latch impaitiently. |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.11 | ColumnoramodLatchSPINGETS | read-only | mandatory | 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 sp… |
| 1.3.6.1.4.1.546.16.4.11.10 | NodeoramodBackups | |||
| 1.3.6.1.4.1.546.16.4.11.10.1 | NodeoramodBackup | |||
| 1.3.6.1.4.1.546.16.4.11.10.1.1 | TableoramodBackupTable | not-accessible | mandatory | Backup Information |
| 1.3.6.1.4.1.546.16.4.11.10.1.1.1 | RoworamodBackupEntry | not-accessible | mandatory | An entry from the backup table. |
| 1.3.6.1.4.1.546.16.4.11.10.1.1.1.1 | ColumnoramodBackupSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.10.1.1.1.2 | ColumnoramodBackupFILENUM | read-only | mandatory | Backup File Index Number. |
| 1.3.6.1.4.1.546.16.4.11.10.1.1.1.3 | ColumnoramodBackupSTATUS | read-only | mandatory | Status of the backup. |
| 1.3.6.1.4.1.546.16.4.11.10.1.1.1.4 | ColumnoramodBackupCHANGENUM | read-only | mandatory | The change number of the backup file. |
| 1.3.6.1.4.1.546.16.4.11.10.1.1.1.5 | ColumnoramodBackupDATE | read-only | mandatory | Date of the Backup. |
| 1.3.6.1.4.1.546.16.4.11.11 | NodeoramodArchive | |||
| 1.3.6.1.4.1.546.16.4.11.11.1 | NodeoramodArcDest | |||
| 1.3.6.1.4.1.546.16.4.11.11.1.1 | TableoramodArcDestTable | not-accessible | mandatory | Archive Information. |
| 1.3.6.1.4.1.546.16.4.11.11.1.1.1 | RoworamodArcDestEntry | not-accessible | mandatory | An entry from the archive destination table. |
| 1.3.6.1.4.1.546.16.4.11.11.1.1.1.1 | ColumnoramodArcDestSIDINDX | read-only | mandatory | Sid Index Number. |
| 1.3.6.1.4.1.546.16.4.11.11.1.1.1.2 | ColumnoramodArcDestARCINDX | read-only | mandatory | Index of Archive log. |
| 1.3.6.1.4.1.546.16.4.11.11.1.1.1.3 | ColumnoramodArcDestARCMODE | read-only | mandatory | Mode of Archive log. |
| 1.3.6.1.4.1.546.16.4.11.11.1.1.1.4 | ColumnoramodArcDestSTATUS | read-only | mandatory | Status of Archive Log File. |
| 1.3.6.1.4.1.546.16.4.11.11.1.1.1.5 | ColumnoramodArcDestDEST | read-only | mandatory | Archive Log File Destination. |
| 1.3.6.1.4.1.546.16.4.12 | NodeoramodTtlFootprt | |||
| 1.3.6.1.4.1.546.16.4.12.1 | ScalaroramodTtlCPUTIME | read-only | mandatory | 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 t… |
| 1.3.6.1.4.1.546.16.4.12.2 | ScalaroramodTtlPERCENTCPU | read-only | mandatory | 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 mu… |
| 1.3.6.1.4.1.546.16.4.12.3 | ScalaroramodTtlMEMSIZE | read-only | mandatory | 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 … |
| 1.3.6.1.4.1.546.16.4.12.4 | ScalaroramodTtlRSS | read-only | mandatory | 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. |
| 1.3.6.1.4.1.546.16.4.12.5 | ScalaroramodTtlPERCENTMEM | read-only | mandatory | The percentage (0-100) of real memory used by the Oracle Application which includes core services and optional connectors. |
| 1.3.6.1.4.1.546.16.4.12.6 | ScalaroramodTtlTHREADS | read-only | mandatory | 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 p… |
| 1.3.6.1.4.1.546.16.4.12.7 | ScalaroramodTtlINBLKS | read-only | mandatory | The number of blocks of data input by the processes. |
| 1.3.6.1.4.1.546.16.4.12.8 | ScalaroramodTtlOUTBLKS | read-only | mandatory | The number of blocks of data put by the processes. |
| 1.3.6.1.4.1.546.16.4.12.9 | ScalaroramodTtlMSGSSENT | read-only | mandatory | The number of messages sent by the processes. |
| 1.3.6.1.4.1.546.16.4.12.10 | ScalaroramodTtlMSGSRCVD | read-only | mandatory | The number of messages received by the processes. |
| 1.3.6.1.4.1.546.16.4.12.11 | ScalaroramodTtlSYSCALLS | read-only | mandatory | The number of system calls invoked by the processes. |
| 1.3.6.1.4.1.546.16.4.12.12 | ScalaroramodTtlMINORPGFLTS | read-only | mandatory | The number of minor page faults incurred by the process. Minor faults do not require I/O to retrieve the page. |
| 1.3.6.1.4.1.546.16.4.12.13 | ScalaroramodTtlMAJORPGFLTS | read-only | mandatory | The number of major page faults incurred by the process. Minor faults require I/O to retrieve the page. |
| 1.3.6.1.4.1.546.16.4.12.14 | ScalaroramodTtlNUMSWAPS | read-only | mandatory | The number of times the processes have been swapped. |
| 1.3.6.1.4.1.546.16.4.12.15 | ScalaroramodTtlVOLCNTX | read-only | mandatory | The number of voluntary context switches incurred by the processes. Voluntary contest switches occur when the processor voluntary gives up the CPU (e.g. waitin… |
| 1.3.6.1.4.1.546.16.4.12.16 | ScalaroramodTtlINVOLCNTX | read-only | mandatory | The number of involuntary context switches incurred by the processes. An involuntary context switch occurs when the process has executed for the duration of it… |
| 1.3.6.1.4.1.546.16.4.12.17 | ScalaroramodTtlDISKSIZE | read-only | mandatory | The size, in KBytes of the Oracle root directory and all the Database Disk storage areas. |