EMPIRE-ORAMOD
AI MIB Summary
Standard SNMP MIB module defining data structures for EMPIRE-ORAMOD.
326
Objects
Active
Status
4
Dependencies
Imported Objects
Objects
326 total| Object Name |
|---|
empire OBJECT IDENTIFIER .1.3.6.1.4.1.546 |
IMPORTS Unknown .1.3.6.1.4.1.546 |
applications OBJECT IDENTIFIER .1.3.6.1.4.1.546.16 |
oracledb OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4 |
oraModVersionDescription and version number of this installation.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.1 |
oraModModeThis 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)ro Enumeration .1.3.6.1.4.1.546.16.4.2 |
oraFlagPerformance flags for this installation.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.3 |
oramodCfg OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.10 |
oramodDbCfg OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.10.1 |
oramodDbCfgTableThis table describes the instance names, index numbers
and initial startup information. SEQUENCE OF OramodDbCfgEntry .1.3.6.1.4.1.546.16.4.10.1.1 |
oramodDbCfgEntryAn entry in the Oracle Configuration table. OramodDbCfgEntry .1.3.6.1.4.1.546.16.4.10.1.1.1 |
oramodDbCfgSIDINDXSid's Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.1 |
oramodDbCfgSIDDatabase Name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.2 |
oramodDbCfgVERSIONDescription and version of this Oracle installation
from v$versionro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.3 |
oramodDbCfgHOMEThe Installation Directory for Oracle or ORACLEHOME.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.4 |
oramodDbCfgBASEThe Base Directory for Oracle or ORACLEBASE.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.5 |
oramodDbCfgIDThe database ID calculated when the database is created
and stored in all file headers (521382036).ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.6 |
oramodDbCfgCRTDTThe original creation date and time of the database.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.7 |
oramodDbCfgLOGMODEThe Archive log mode: NOARCHIVELOG or ARCHIVELOG.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.8 |
oramodDbCfgCTRLFILETYPEControl File Type. Can be the following types :
CURRENT,STANDBY,CLONE,BACKUP,CREATED.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.9 |
oramodDbCfgOPENMODEShows whether the database is set to READ WRITE
or READ ONLY (NEW TO 8i.).ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.10 |
oramodDbCfgMAXPROCESSFor 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/dependentro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.11 |
oramodDbCfgMAXSESSIONMaximum number of User and System Sessions.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.12 |
oramodDbCfgTIMEDSTATISTICSTRUE/FALSE: sets timing on. Should be false for
maximum performance.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.13 |
oramodDbCfgCPUCNTThe maximum number of CPU's for this instance.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.14 |
oramodDbCfgSHAREDPOOLSIZEShared 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.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.15 |
oramodDbCfgSHAREDPOOLRSSIZEShared Pool Reserved Size Kbytes.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.16 |
oramodDbCfgLARGEPOOLSIZELarge Pool Reserved Size Kbytes.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.17 |
oramodDbCfgJAVAPOOLSIZEJava Pool Size in Kbytes Default is (20000K)ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.18 |
oramodDbCfgCNTRLFILESName and path of control files. String of file names.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.1.1.1.19 |
oramodDbCfgDBBLKBUFFNumber of Database Block Buffers in blocks. Controls
how much memory is available in the buffer cache for data
blocks. Default is (26240)ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.20 |
oramodDbCfgDBBLKSIZESize of Database Blocks. O/S dependentro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.21 |
oramodDbCfgCKPTINTRVLRedo Log Checkpoint Interval.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.22 |
oramodDbCfgDBFILESMaximum Number of Database Files.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.23 |
oramodDbCfgSORTAREASIZEMaximum 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.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.24 |
oramodDbCfgOPENCURSORSMaximum open cursors a single-user process can have
at once. Typical Range (1 - 2147483647).ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.25 |
oramodDbCfgTRNSACTNSMaximum number of concurrent transactions allowed at
one time.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.26 |
oramodDbCfgTRNSACTNSPERSEGMaximum number of concurrent transactions per segment.
Default is 30. O/S dependent.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.27 |
oramodDbCfgMAXROLLSEGMaximum number of rollback segments.ro INTEGER .1.3.6.1.4.1.546.16.4.10.1.1.1.28 |
oramodCfgDf OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.10.2 |
oramodCfgDfTableThis table describes the database files for the database. SEQUENCE OF OramodCfgDfEntry .1.3.6.1.4.1.546.16.4.10.2.1 |
oramodCfgDfEntryAn entry in the Oracle v$datafile table. OramodCfgDfEntry .1.3.6.1.4.1.546.16.4.10.2.1.1 |
oramodCfgDfSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.1 |
oramodCfgDfFILENUMFile Identification Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.2 |
oramodCfgDfSTATUSType of file (system or user) and its status.
Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF(an offline
file from the SYSTEM tablespace).ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.2.1.1.3 |
oramodCfgDfENABLEDDescribes how accessible the file is from SQL. Can be
DISABLED, READ ONLY, READ WRITE and UNKNOWN.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.2.1.1.4 |
oramodCfgDfUNRCVRBLECHGThe last unrecoverbale change number made to this datafile.
Always updated when an unrecoverable operation completes.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.5 |
oramodCfgDfUNRCVRBLETIMEThe last unrecoverbale change time made to this datafile.
Always updated when an unrecoverable operation completes.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.6 |
oramodCfgDfKBYTESCurrent size in kbytes; 0 if unaccessible.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.7 |
oramodCfgDfCRTKBYTESSize when created.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.8 |
oramodCfgDfFNAMEName of the file.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.2.1.1.9 |
oramodCfgDfCRTTIMETime at which the datafile was created.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.2.1.1.10 |
oramodCfgDfTBLESPACENUMTablespace Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.11 |
oramodCfgDfTBLESPACERFILENUMTablespace Relative Df Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.12 |
oramodCfgDfBLOCKSCurrent datafile size in blocks; 0 if inaccessible.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.13 |
oramodCfgDfBLOCKSIZEBlock size of the datafile.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.14 |
oramodCfgDfERRORNULL if the header read success. If error must restore.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.15 |
oramodCfgDfRECOVERYES/NO File needs media recovery.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.2.1.1.16 |
oramodCfgDfRSTLOGSCHGNUMReset Logs change number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.2.1.1.17 |
oramodCfgDfRSTLOGSTIMEReset Logs timestamp.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.2.1.1.18 |
oramodCfgLf OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.10.3 |
oramodCfgLfTableThis table describes the redo log files locations
for each Oracle installation from v$logfile. SEQUENCE OF OramodCfgLfEntry .1.3.6.1.4.1.546.16.4.10.3.1 |
oramodCfgLfEntryAn entry in the Oracle Logfile table. OramodCfgLfEntry .1.3.6.1.4.1.546.16.4.10.3.1.1 |
oramodCfgLfSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.3.1.1.1 |
oramodCfgLfMEMBERINDXLogfile member index.ro INTEGER .1.3.6.1.4.1.546.16.4.10.3.1.1.2 |
oramodCfgLfGROUPNUMGroup Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.3.1.1.3 |
oramodCfgLfSTATUSStatus of File.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.3.1.1.4 |
oramodCfgLfMEMBERFile name and path.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.10.3.1.1.5 |
oramodCfgSga OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.10.4 |
oramodCfgSgaTableThis table summarizes the system global area. SEQUENCE OF OramodCfgSgaEntry .1.3.6.1.4.1.546.16.4.10.4.1 |
oramodCfgSgaEntryAn entry in the Oracle Sga table. OramodCfgSgaEntry .1.3.6.1.4.1.546.16.4.10.4.1.1 |
oramodCfgSgaSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.10.4.1.1.1 |
oramodCfgSgaTOTALMEMALLOCTotal real memory allocated. Summation of values in v$sga.ro INTEGER .1.3.6.1.4.1.546.16.4.10.4.1.1.2 |
oramodCfgSgaFIXEDSGAFixed memory allocated in Kbytesro INTEGER .1.3.6.1.4.1.546.16.4.10.4.1.1.3 |
oramodCfgSgaVARIABLEVariable Memory allocated in the SGAro INTEGER .1.3.6.1.4.1.546.16.4.10.4.1.1.4 |
oramodCfgSgaDBBUFFDatabase buffers allocated in Kbytes. Typical Range is
4 Kbytes - 2 Gbytes.ro INTEGER .1.3.6.1.4.1.546.16.4.10.4.1.1.5 |
oramodCfgSgaREDOBUFFRedo Buffers allocated in Kbytesro INTEGER .1.3.6.1.4.1.546.16.4.10.4.1.1.6 |
oramodPerf OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11 |
oramodFootprint OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.1 |
oramodFootprt OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.1.1 |
oramodFootprtTableThis table describes the system footprint. SEQUENCE OF OramodFootprtEntry .1.3.6.1.4.1.546.16.4.11.1.1.1 |
oramodFootprtEntryAn entry in the Oracle Footprint table. OramodFootprtEntry .1.3.6.1.4.1.546.16.4.11.1.1.1.1 |
oramodFootprtSIDINDXEmpire's Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.1.1.1.1 |
oramodFootprtCPUTIMECPU 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.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.1.1.1.2 |
oramodFootprtPERCENTCPUThe 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'ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.1.1.1.3 |
oramodFootprtMEMSIZEThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.1.1.1.1.4 |
oramodFootprtRSSThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.1.1.1.1.5 |
oramodFootprtPERCENTMEMThe percentage (0-100) of real memory used by
the Oracle Application which includes core
services and optional connectors.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.1.1.1.6 |
oramodFootprtTHREADSThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.1.1.1.1.7 |
oramodFootprtINBLKSThe number of blocks of data input by the processes.ro Gauge .1.3.6.1.4.1.546.16.4.11.1.1.1.1.8 |
oramodFootprtOUTBLKSThe number of blocks of data put by the processes.ro Gauge .1.3.6.1.4.1.546.16.4.11.1.1.1.1.9 |
oramodFootprtMSGSSENTThe number of messages sent by the processes.ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.10 |
oramodFootprtMSGSRCVDThe number of messages received by the processes.ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.11 |
oramodFootprtSYSCALLSThe number of system calls invoked by the processes.ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.12 |
oramodFootprtMINORPGFLTSThe number of minor page faults incurred by the process.
Minor faults do not require I/O to retrieve the page.ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.13 |
oramodFootprtMAJORPGFLTSThe number of major page faults incurred by the process.
Minor faults require I/O to retrieve the page.ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.14 |
oramodFootprtNUMSWAPSThe number of times the processes have been swapped.ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.15 |
oramodFootprtVOLCNTXThe 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).ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.16 |
oramodFootprtINVOLCNTXThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.1.1.1.1.17 |
oramodFootprtHOMESIZEThe size, in KBytes of the Oracle root directory
and all files beneath it.ro Gauge .1.3.6.1.4.1.546.16.4.11.1.1.1.1.18 |
oramodFootprtDBDISKSIZEThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.1.1.1.1.19 |
oramodFootprtLASTUPDATEThe time (based on sysUpTime) that the last update
of all variables in the table was completed.ro TimeTicks (SNMPv2-SMI) .1.3.6.1.4.1.546.16.4.11.1.1.1.1.20 |
oramodFFootprt OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.1.2 |
oramodFFootprtTableThis table describes the system footprint. SEQUENCE OF OramodFFootprtEntry .1.3.6.1.4.1.546.16.4.11.1.2.1 |
oramodFFootprtEntryAn entry in the Oracle File Footprint table. OramodFFootprtEntry .1.3.6.1.4.1.546.16.4.11.1.2.1.1 |
oramodFFootprtSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.2.1.1.1 |
oramodFFootprtFILEINDXFile Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.2.1.1.2 |
oramodFFootprtFILETYPEFile Type.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.1.2.1.1.3 |
oramodFFootprtFILENAMEFile Name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.1.2.1.1.4 |
oramodFFootprtCRTTSLast update timestamp.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.1.2.1.1.5 |
oramodFFootprtCRTKBYTESFile creation kbytes.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.2.1.1.6 |
oramodFFootprtKBYTESFile kbytes.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.2.1.1.7 |
oramodFFootprtBLOCKSFile blocks.ro INTEGER .1.3.6.1.4.1.546.16.4.11.1.2.1.1.8 |
oramodFFootprtSTATUSFile Status.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.1.2.1.1.9 |
oramodFFootprtRECOVERLast Recover timestamp.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.1.2.1.1.10 |
oramodFFootprtAVGIOTIMFile average I/O time.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.1.2.1.1.11 |
oramodMetrics OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.2 |
oramodMetricsTableThis table describes the database metrics. SEQUENCE OF OramodMetricsEntry .1.3.6.1.4.1.546.16.4.11.2.1 |
oramodMetricsEntryAn entry in the Metrics table. OramodMetricsEntry .1.3.6.1.4.1.546.16.4.11.2.1.1 |
oramodMetricsSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.2.1.1.1 |
oramodMetricsBCPTBlock 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.2 |
oramodMetricsBGRBlock 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.3 |
oramodMetricsBVPTBlock 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.4 |
oramodMetricsCHRCache 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.5 |
oramodMetricsCRCall 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.6 |
oramodMetricsCPTCalls 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.7 |
oramodMetricsCBRChanged 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.8 |
oramodMetricsCCRConsistent 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.9 |
oramodMetricsCRRContinued 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.10 |
oramodMetricsLCMLibrary 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.11 |
oramodMetricsRTUCRecursive 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.12 |
oramodMetricsRLSWRedo 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.13 |
oramodMetricsRSRRow 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.14 |
oramodMetricsSORSort 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.15 |
oramodMetricsTRRTransaction 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.16 |
oramodMetricsUCRUser 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.17 |
oramodMetricsUCPPUser 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.18 |
oramodMetricsURRUser 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.19 |
oramodMetricsSGALCELibrary 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.20 |
oramodMetricsSGADDCEData 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.21 |
oramodMetricsDBTOTALRWThe total number of physical reads and physical writes
since instance startup. See individual descriptions below.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.22 |
oramodMetricsDBBLKCHGThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.23 |
oramodMetricsDBBLKGETThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.24 |
oramodMetricsDBCNSTGETThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.25 |
oramodMetricsDBPHYSREADThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.26 |
oramodMetricsDBSORTDISKThe total number of database disk sorts since instance
startup. It increments for each sort which has to allocate
disk work space. Should be zero.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.27 |
oramodMetricsDBSORTMEMThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.28 |
oramodMetricsBLKFREEWAITThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.29 |
oramodMetricsMTHRDQUEUEWAITThe number of seconds waited in queue
for multi-threaded servers.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.30 |
oramodMetricsSESSHIWTRMEMThe maximum highwater amount of session memory used.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.31 |
oramodMetricsSESSCURRMEMThe current maximum amount of session memory used.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.32 |
oramodMetricsSESSHIWTRThe highwater mark for number of sessions.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.33 |
oramodMetricsSESSCURRENTThe current number of sessions.ro Gauge .1.3.6.1.4.1.546.16.4.11.2.1.1.34 |
oramodMetricsUSERCOMMITSRecords 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.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.35 |
oramodMetricsUSERROLLBACKThe number of transactions rolled back since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.36 |
oramodMetricsUSERCALLSThe number of transactions started since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.37 |
oramodMetricsDBPHYSWRTSThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.38 |
oramodMetricsTBLSCANROWSThe number of rows retrieved through table scans since
instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.39 |
oramodMetricsTBLFTCHROWIDThe number of rows retrieved through table fetches by
rowid since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.40 |
oramodMetricsTBLFTCHCROWThe number of rows retrieved through table fetches by
continued row since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.41 |
oramodMetricsRECRSVCALLSThe number of recursive calls since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.42 |
oramodMetricsCNSTCHGSThe number of consistent changes since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.43 |
oramodMetricsPARSECNTThe number of parses since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.2.1.1.44 |
oramodMetricsCPUTMThe amount of time taken to work requests.ro INTEGER .1.3.6.1.4.1.546.16.4.11.2.1.1.45 |
oramodMetricsLOGFILESWTCHThe number of redo log file switches.ro INTEGER .1.3.6.1.4.1.546.16.4.11.2.1.1.46 |
oramodMetricsARCHIVERThe database archiver.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.2.1.1.47 |
oramodMetricsDATABASESTATUSThe status of the database.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.2.1.1.48 |
oramodMetricsSHUTDOWNPENDINGThe shutdown status of the database.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.2.1.1.49 |
oramodMetricsLASTUPDATEThe time (based on sysUpTime) that the last update
of all variables in the table was completed.ro TimeTicks (SNMPv2-SMI) .1.3.6.1.4.1.546.16.4.11.2.1.1.50 |
oramodSGA OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.3 |
oramodSgaDddAgg OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.3.1 |
oramodSgaDddAggTableThis table describes the data dictionary aggregates. SEQUENCE OF OramodSgaDddAggEntry .1.3.6.1.4.1.546.16.4.11.3.1.1 |
oramodSgaDddAggEntryAn entry in the Data Dictionary Aggregate table. OramodSgaDddAggEntry .1.3.6.1.4.1.546.16.4.11.3.1.1.1 |
oramodSGAAGGSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.3.1.1.1.1 |
oramodSGAAGGCNTTotal number of entries in the data dictionary cache
since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.2 |
oramodSGAAGGUSGEThe total number of cache entries with valid data since
instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.3 |
oramodSGAAGGFIXThe total number of fixed entries in the data dictionary
cache since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.4 |
oramodSGAAGGGETThe total number of information requests since instance
startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.5 |
oramodSGAAGGGETMISSThe total number of informations requests resulting in
cache misses since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.6 |
oramodSGAAGGSCANThe total number of scan requests since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.7 |
oramodSGAAGGSCANMISSThe total number of scan requests resulting in misses
since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.8 |
oramodSGAAGGSCANCPLTFor subordinate entries, the total number of times
list was scanned completely since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.9 |
oramodSGAAGGMODSThe total number of inserts, updates, and deletions
since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.10 |
oramodSGAAGGFLUSHThe total number of times flushed to disk since instance
startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.1.1.1.11 |
oramodSgaDlci OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.3.2 |
oramodSgaDlciTableThis table describes the detailed library cache information. SEQUENCE OF OramodSgaDlciEntry .1.3.6.1.4.1.546.16.4.11.3.2.1 |
oramodSgaDlciEntryAn entry in the Library Cache table. OramodSgaDlciEntry .1.3.6.1.4.1.546.16.4.11.3.2.1.1 |
oramodSGADLCISIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.3.2.1.1.1 |
oramodSGADLCIINDXNamespace Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.3.2.1.1.2 |
oramodSGADLCINAMELibrary Cache Namespace. (SQL AREA, TABLE/PROCEDURE, BODY,
TRIGGER, INDEX, CLUSTER, OBJECT, PIPE)ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.3.2.1.1.3 |
oramodSGADLCIGETThe total number of request handles to library namespace
since instance startup Typical range (0..500,00).ro Counter .1.3.6.1.4.1.546.16.4.11.3.2.1.1.4 |
oramodSGADLCIGETHITThe total number of times handles are already allocated
in the cache. If the handle is not already allocated it is a
miss.ro Counter .1.3.6.1.4.1.546.16.4.11.3.2.1.1.5 |
oramodSGADLCIGETHITRTThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.3.2.1.1.6 |
oramodSGADLCIPINThe total number of pin requests for objects in the cache
since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.3.2.1.1.7 |
oramodSGADLCIPINHITThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.3.2.1.1.8 |
oramodSGADLCIPINHITRTThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.3.2.1.1.9 |
oramodSGADLCIRELOADNumber 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.ro Counter .1.3.6.1.4.1.546.16.4.11.3.2.1.1.10 |
oramodSGADLCIINVALIDThe number of times that non-persistant library objects
(like SQL areas) have been invalidated.ro Counter .1.3.6.1.4.1.546.16.4.11.3.2.1.1.11 |
oramodRedoLogBuf OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.4 |
oramodRedoLogBufTableThis table describes the Redo Log information. SEQUENCE OF OramodRedoLogBufEntry .1.3.6.1.4.1.546.16.4.11.4.1 |
oramodRedoLogBufEntryAn entry in the Redo Log table. OramodRedoLogBufEntry .1.3.6.1.4.1.546.16.4.11.4.1.1 |
oramodREDOSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.4.1.1.1 |
oramodREDOBLKWRTThe total number of redo blocks written since instance
startup.ro Counter .1.3.6.1.4.1.546.16.4.11.4.1.1.2 |
oramodREDOENTRIESThe total number of redo entries in the redo log since
instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.4.1.1.3 |
oramodREDOSIZEThe size of the redo log.ro INTEGER .1.3.6.1.4.1.546.16.4.11.4.1.1.4 |
oramodREDOSPACERQSTThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.4.1.1.5 |
oramodREDOSPACEWAITThe total number of redo log space wait time since
instance startupro Counter .1.3.6.1.4.1.546.16.4.11.4.1.1.6 |
oramodREDOSYNCHWRTThe total number of redo synch writes since instance
startup.ro Counter .1.3.6.1.4.1.546.16.4.11.4.1.1.7 |
oramodREDOSYNCHTMThe amount of redo log synch time.ro INTEGER .1.3.6.1.4.1.546.16.4.11.4.1.1.8 |
oramodREDOWASTAGEThe total amount of redo log wastage.ro Counter .1.3.6.1.4.1.546.16.4.11.4.1.1.9 |
oramodREDORETRIESThe total number of redo retries.ro Counter .1.3.6.1.4.1.546.16.4.11.4.1.1.10 |
oramodREDOLASTUPDATEThe time (based on sysUpTime) that the last update
of all variables in the table was completed.ro TimeTicks (SNMPv2-SMI) .1.3.6.1.4.1.546.16.4.11.4.1.1.11 |
oramodRollBack OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.5 |
oramodRollBackTableThis table describes any rollback segments. SEQUENCE OF OramodRollBackEntry .1.3.6.1.4.1.546.16.4.11.5.1 |
oramodRollBackEntryAn entry in the rollstat table. OramodRollBackEntry .1.3.6.1.4.1.546.16.4.11.5.1.1 |
oramodRollBackSIDINDXSID Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.5.1.1.1 |
oramodRollBackSEGINDXUndo Segment Number used as an index.ro INTEGER .1.3.6.1.4.1.546.16.4.11.5.1.1.2 |
oramodRollBackSEGNAMERollback Segment Name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.5.1.1.3 |
oramodRollBackEXTENTSThe total number of Segment Extends since instance
startup.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.4 |
oramodRollBackRSSIZEThe size of the Rollback Segment.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.5 |
oramodRollBackWRITESThe total number of Segment Writes since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.6 |
oramodRollBackGETSThe total number of Rollback Segment Gets since
instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.7 |
oramodRollBackWAITSThe total number of Segment Waits since instance startup.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.8 |
oramodRollBackOPTSIZEThe Optimal Size of the Rollback Segment. This size should
be set based on application usage to minimize space management
issues.ro INTEGER .1.3.6.1.4.1.546.16.4.11.5.1.1.9 |
oramodRollBackSHRINKSThe total number of Rollback Segment Shrinks since
instance startup. Rollback Segments shrink back to their
optimal size after extends have occurred.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.10 |
oramodRollBackWRAPSThe 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.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.11 |
oramodRollBackEXTENDSRollback 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.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.12 |
oramodRollBackAVESHRINKThe average shrink size of the Rollback Segment since
this instance startup.ro INTEGER .1.3.6.1.4.1.546.16.4.11.5.1.1.13 |
oramodRollBackAVEACTIVESegment average active.ro Counter .1.3.6.1.4.1.546.16.4.11.5.1.1.14 |
oramodRollBackSTATUSSegment status.ro INTEGER .1.3.6.1.4.1.546.16.4.11.5.1.1.15 |
oramodWaits OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.6 |
oramodWaitsTableThis table describes resource waits. SEQUENCE OF OramodWaitsEntry .1.3.6.1.4.1.546.16.4.11.6.1 |
oramodWaitsEntryAn entry in the waits table. OramodWaitsEntry .1.3.6.1.4.1.546.16.4.11.6.1.1 |
oramodWaitsSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.6.1.1.1 |
oramodWaitsEVENTINDXEvent's Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.6.1.1.2 |
oramodWaitsEVENTResource Name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.6.1.1.3 |
oramodWaitsTOTALWAITSResource Total Waits.ro Counter .1.3.6.1.4.1.546.16.4.11.6.1.1.4 |
oramodWaitsTOTALTIMOUTResource Total Timeouts.ro Counter .1.3.6.1.4.1.546.16.4.11.6.1.1.5 |
oramodWaitsTIMEWAITEDResource Total Waited.ro Counter .1.3.6.1.4.1.546.16.4.11.6.1.1.6 |
oramodWaitsAVGWAITResource average wait.ro Counter .1.3.6.1.4.1.546.16.4.11.6.1.1.7 |
oramodExpSql OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.7 |
oramodExpSqlTableThis table describes expensive sql. SEQUENCE OF OramodExpSqlEntry .1.3.6.1.4.1.546.16.4.11.7.1 |
oramodExpSqlEntryAn entry in the v$sqlarea table. OramodExpSqlEntry .1.3.6.1.4.1.546.16.4.11.7.1.1 |
oramodExpSqlSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.7.1.1.1 |
oramodExpSqlSQLINDXSQL Statement Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.7.1.1.2 |
oramodExpSqlEXECUTIONNumber of Executions.ro Gauge .1.3.6.1.4.1.546.16.4.11.7.1.1.3 |
oramodExpSqlDISKREADNumber of Disk Reads.ro Gauge .1.3.6.1.4.1.546.16.4.11.7.1.1.4 |
oramodExpSqlPARSECNTNumber 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.ro Gauge .1.3.6.1.4.1.546.16.4.11.7.1.1.5 |
oramodExpSqlBUFFGETSNumber of Buffer Gets.ro Gauge .1.3.6.1.4.1.546.16.4.11.7.1.1.6 |
oramodExpSqlSORTSNumber of Sorts.ro Gauge .1.3.6.1.4.1.546.16.4.11.7.1.1.7 |
oramodExpSqlSQLSql Statement truncated.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.7.1.1.8 |
oramodTblsp OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.8 |
oramodTblspTableList Fragmentation Information. SEQUENCE OF OramodTblspEntry .1.3.6.1.4.1.546.16.4.11.8.1 |
oramodTblspEntryAn entry from the dbafreespace table. OramodTblspEntry .1.3.6.1.4.1.546.16.4.11.8.1.1 |
oramodTblspSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.8.1.1.1 |
oramodTblspTBLSPINDXTablespace Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.8.1.1.2 |
oramodTblspTBLSPNAMETablespace Name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.8.1.1.3 |
oramodTblspFILENAMEFile Name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.8.1.1.4 |
oramodTblspEXTENTSThe number of extents.ro Gauge .1.3.6.1.4.1.546.16.4.11.8.1.1.5 |
oramodTblspLRGEXTENTSize in bytes of the largest extent.ro Gauge .1.3.6.1.4.1.546.16.4.11.8.1.1.6 |
oramodTblspSMEXTENTSize in bytes of the smallest extent.ro Gauge .1.3.6.1.4.1.546.16.4.11.8.1.1.7 |
oramodTblspINCREMENTBYSize in bytes of the next extent increment.ro INTEGER .1.3.6.1.4.1.546.16.4.11.8.1.1.8 |
oramodTblspBYTESCOALSDThe number of free bytes that were coalesed. If
this number does not match bytesfree then the tablespace
has some extents that can be coalesced.ro Gauge .1.3.6.1.4.1.546.16.4.11.8.1.1.9 |
oramodTblspBYTESFREEThe total number of free bytes available.ro Gauge .1.3.6.1.4.1.546.16.4.11.8.1.1.10 |
oramodLocks OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.9 |
oramodLock OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.9.1 |
oramodLockTableLock Holders and Requestors SEQUENCE OF OramodLockEntry .1.3.6.1.4.1.546.16.4.11.9.1.1 |
oramodLockEntryAn entry from the lock and session tables. OramodLockEntry .1.3.6.1.4.1.546.16.4.11.9.1.1.1 |
oramodLockSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.1.1.1.1 |
oramodLockUSERINDXUser's Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.1.1.1.2 |
oramodLockUSERNAMEUser Name holding the lock.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.9.1.1.1.3 |
oramodLockOBJECTThe name of the locked object.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.9.1.1.1.4 |
oramodLockTYPEObject Type.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.9.1.1.1.5 |
oramodLockMODELock Mode held (Null, Row share, Row exclusive, Share,
Share row exclusive, Exclusive).ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.1.1.1.6 |
oramodLockCTIMETime since current mode was granted.ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.1.1.1.7 |
oramodLockBLOCKThe lock is blocking another lock.ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.1.1.1.8 |
oramodLatch OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.9.2 |
oramodLatchTableLatch information. SEQUENCE OF OramodLatchEntry .1.3.6.1.4.1.546.16.4.11.9.2.1 |
oramodLatchEntryAn entry from the latch table. OramodLatchEntry .1.3.6.1.4.1.546.16.4.11.9.2.1.1 |
oramodLatchSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.2.1.1.1 |
oramodLatchLATCHINDXLatch Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.2.1.1.2 |
oramodLatchLATCHNUMLatch Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.9.2.1.1.3 |
oramodLatchLATCHNAMELatch Name.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.9.2.1.1.4 |
oramodLatchGETSLatch Gets. Reflects the proportion of times requests
for latches are satisfied without waiting. Should be high.ro Counter .1.3.6.1.4.1.546.16.4.11.9.2.1.1.5 |
oramodLatchMISSESLatch Misses.ro Counter .1.3.6.1.4.1.546.16.4.11.9.2.1.1.6 |
oramodLatchSLEEPSLatch Sleeps.ro Counter .1.3.6.1.4.1.546.16.4.11.9.2.1.1.7 |
oramodLatchIMDGETSLatch Immediate Gets.ro Counter .1.3.6.1.4.1.546.16.4.11.9.2.1.1.8 |
oramodLatchIMDMISSESLatch Immediate Misses.ro Counter .1.3.6.1.4.1.546.16.4.11.9.2.1.1.9 |
oramodLatchWAITSHOLDINGLatch Immediate Misses. When a session cannot acquire
a latch, it goes into active wait and repeatedly trys
to acquire the latch impaitiently.ro Counter .1.3.6.1.4.1.546.16.4.11.9.2.1.1.10 |
oramodLatchSPINGETSLatch 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.ro Counter .1.3.6.1.4.1.546.16.4.11.9.2.1.1.11 |
oramodBackups OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.10 |
oramodBackup OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.10.1 |
oramodBackupTableBackup Information SEQUENCE OF OramodBackupEntry .1.3.6.1.4.1.546.16.4.11.10.1.1 |
oramodBackupEntryAn entry from the backup table. OramodBackupEntry .1.3.6.1.4.1.546.16.4.11.10.1.1.1 |
oramodBackupSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.10.1.1.1.1 |
oramodBackupFILENUMBackup File Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.10.1.1.1.2 |
oramodBackupSTATUSStatus of the backup.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.10.1.1.1.3 |
oramodBackupCHANGENUMThe change number of the backup file.ro INTEGER .1.3.6.1.4.1.546.16.4.11.10.1.1.1.4 |
oramodBackupDATEDate of the Backup.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.10.1.1.1.5 |
oramodArchive OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.11 |
oramodArcDest OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.11.11.1 |
oramodArcDestTableArchive Information. SEQUENCE OF OramodArcDestEntry .1.3.6.1.4.1.546.16.4.11.11.1.1 |
oramodArcDestEntryAn entry from the archive destination table. OramodArcDestEntry .1.3.6.1.4.1.546.16.4.11.11.1.1.1 |
oramodArcDestSIDINDXSid Index Number.ro INTEGER .1.3.6.1.4.1.546.16.4.11.11.1.1.1.1 |
oramodArcDestARCINDXIndex of Archive log.ro INTEGER .1.3.6.1.4.1.546.16.4.11.11.1.1.1.2 |
oramodArcDestARCMODEMode of Archive log.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.11.1.1.1.3 |
oramodArcDestSTATUSStatus of Archive Log File.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.11.1.1.1.4 |
oramodArcDestDESTArchive Log File Destination.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.546.16.4.11.11.1.1.1.5 |
oramodTtlFootprt OBJECT IDENTIFIER .1.3.6.1.4.1.546.16.4.12 |
oramodTtlCPUTIMECPU 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.ro INTEGER .1.3.6.1.4.1.546.16.4.12.1 |
oramodTtlPERCENTCPUThe 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'ro INTEGER .1.3.6.1.4.1.546.16.4.12.2 |
oramodTtlMEMSIZEThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.12.3 |
oramodTtlRSSThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.12.4 |
oramodTtlPERCENTMEMThe percentage (0-100) of real memory used by
the Oracle Application which includes core
services and optional connectors.ro INTEGER .1.3.6.1.4.1.546.16.4.12.5 |
oramodTtlTHREADSThe 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.ro Gauge .1.3.6.1.4.1.546.16.4.12.6 |
oramodTtlINBLKSThe number of blocks of data input by the processes.ro Gauge .1.3.6.1.4.1.546.16.4.12.7 |
oramodTtlOUTBLKSThe number of blocks of data put by the processes.ro Gauge .1.3.6.1.4.1.546.16.4.12.8 |
oramodTtlMSGSSENTThe number of messages sent by the processes.ro Counter .1.3.6.1.4.1.546.16.4.12.9 |
oramodTtlMSGSRCVDThe number of messages received by the processes.ro Counter .1.3.6.1.4.1.546.16.4.12.10 |
oramodTtlSYSCALLSThe number of system calls invoked by the processes.ro Counter .1.3.6.1.4.1.546.16.4.12.11 |
oramodTtlMINORPGFLTSThe number of minor page faults incurred by the process.
Minor faults do not require I/O to retrieve the page.ro Counter .1.3.6.1.4.1.546.16.4.12.12 |
oramodTtlMAJORPGFLTSThe number of major page faults incurred by the process.
Minor faults require I/O to retrieve the page.ro Counter .1.3.6.1.4.1.546.16.4.12.13 |
oramodTtlNUMSWAPSThe number of times the processes have been swapped.ro Counter .1.3.6.1.4.1.546.16.4.12.14 |
oramodTtlVOLCNTXThe 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).ro Counter .1.3.6.1.4.1.546.16.4.12.15 |
oramodTtlINVOLCNTXThe 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.ro Counter .1.3.6.1.4.1.546.16.4.12.16 |
oramodTtlDISKSIZEThe size, in KBytes of the Oracle root directory
and all the Database Disk storage areas.ro INTEGER .1.3.6.1.4.1.546.16.4.12.17 |