ORADB-MIB Table View

Table-centric layout grouping table, row, and column objects.

Tables
7
Rows
7
Columns
87

oraDbSysTable

table mandatory
.1.3.6.1.4.1.111.4.1.1 · 1 row entry · 25 columns
Uses the oracle variant from /opt/observium/mibs/oracle.
Command help
Walk oraDbSysTable
/usr/bin/snmpbulkwalk -v2c -c '<community>' -Pud -Ir -OQUs -m 'ORADB-MIB' -M '/opt/observium/mibs/oracle:/opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp' 'udp:<hostname>:161' 'ORADB-MIB::oraDbSysTable'
Oracle-specific performance information global to a database.
oraDbSysEntry row .1.3.6.1.4.1.111.4.1.1.1
Selected info from the v$sysstat table on instance performance.
Variables are included here
because they have been found particularly useful in
tuning an Oracle instance. In many cases, the variable should
only be con…
Column Syntax OID
the 'consistent changes' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.1
the 'consistent gets' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.2
the 'Db block changes' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.3
the 'db block gets' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.4
the 'free buffer inspected' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.5
the 'free buffer requested' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.6
the 'parse count' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.7
the 'physical reads' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.8
the 'physical writes' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.9
the 'redo entries' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.10
the 'redo log space requests' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.11
the 'redo synch writes' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.12
the 'sorts (disk)' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.13
the 'sorts (memory)' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.14
the 'sorts (rows)' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.15
the 'table fetch by rowid' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.16
the 'table fetch continued row' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.17
the 'table scan blocks gotten' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.18
the 'table scan rows gotten' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.19
the 'table scans (long tables)' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.20
the 'table scans (short tables)' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.21
the 'user calls' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.22
the 'user commits' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.23
the 'user rollbacks' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.24
the 'write requests' parameter from v$sysstat
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.1.1.25

oraDbTablespaceTable

table mandatory
.1.3.6.1.4.1.111.4.1.2 · 1 row entry · 6 columns
Uses the oracle variant from /opt/observium/mibs/oracle.
Command help
Walk oraDbTablespaceTable
/usr/bin/snmpbulkwalk -v2c -c '<community>' -Pud -Ir -OQUs -m 'ORADB-MIB' -M '/opt/observium/mibs/oracle:/opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp' 'udp:<hostname>:161' 'ORADB-MIB::oraDbTablespaceTable'
Information on tablespaces within an Oracle database.
oraDbTablespaceEntry row .1.3.6.1.4.1.111.4.1.2.1
Information for each tablespace within an Oracle database.
Column Syntax OID
A numeric index, unique among tablespaces within a single
Oracle database.
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.2.1.1
The name of this tablespace.
RFC1213-MIBDisplayString .1.3.6.1.4.1.111.4.1.2.1.2
The amount of disk space, in kilobytes, allocated for this
tablespace. This is the sum of the sizes of the data files
associated with the tablespace.
Integer32
Constraints:
range: -2147483648-2147483647
.1.3.6.1.4.1.111.4.1.2.1.3
The amount of disk space, in kilobytes, which is actually in
use for storing data.
Integer32
Constraints:
range: -2147483648-2147483647
.1.3.6.1.4.1.111.4.1.2.1.4
The current accessibility of this tablespace. If a
tablespace is offline(2), then SQL statements cannot
reference objects contained in the tablespace. An invalid(3)
tablespace is one that has been dropped.
Enumeration
Enumerated Values:
1online
2offline
3invalid
.1.3.6.1.4.1.111.4.1.2.1.5
The size, in kilobytes, of the largest contiguous set of free
data blocks in the tablespace.
Integer32
Constraints:
range: -2147483648-2147483647
.1.3.6.1.4.1.111.4.1.2.1.6

oraDbDataFileTable

table mandatory
.1.3.6.1.4.1.111.4.1.3 · 1 row entry · 9 columns
Uses the oracle variant from /opt/observium/mibs/oracle.
Command help
Walk oraDbDataFileTable
/usr/bin/snmpbulkwalk -v2c -c '<community>' -Pud -Ir -OQUs -m 'ORADB-MIB' -M '/opt/observium/mibs/oracle:/opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp' 'udp:<hostname>:161' 'ORADB-MIB::oraDbDataFileTable'
Information on data files within an Oracle database.
oraDbDataFileEntry row .1.3.6.1.4.1.111.4.1.3.1
Information for each data file within an Oracle database.
Column Syntax OID
A numeric index, unique among data files associated with a
single tablespace.
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.3.1.1
The fully-qualified name of this datafile.
RFC1213-MIBDisplayString .1.3.6.1.4.1.111.4.1.3.1.2
The allocated size, in kilobytes, of this data file.
Integer32
Constraints:
range: -2147483648-2147483647
.1.3.6.1.4.1.111.4.1.3.1.3
The total number of reads issued against this data file since
startup.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.3.1.4
The total number of writes issued against this data file since
startup.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.3.1.5
The total number of physical blocks read from this data file
since startup.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.3.1.6
The total number of physical blocks written to this data file
since startup.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.3.1.7
The time spent reading from this data file since startup IF
the database parameter TIMED_STATISTICS is TRUE. If
TIMED_STATISTICS is FALSE, then the value will be zero.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.3.1.8
The time spent writing to this data file since startup IF
the database parameter TIMED_STATISTICS is TRUE. If
TIMED_STATISTICS is FALSE, then the value will be zero.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.3.1.9

oraDbLibraryCacheTable

table mandatory
.1.3.6.1.4.1.111.4.1.4 · 1 row entry · 8 columns
Uses the oracle variant from /opt/observium/mibs/oracle.
Command help
Walk oraDbLibraryCacheTable
/usr/bin/snmpbulkwalk -v2c -c '<community>' -Pud -Ir -OQUs -m 'ORADB-MIB' -M '/opt/observium/mibs/oracle:/opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp' 'udp:<hostname>:161' 'ORADB-MIB::oraDbLibraryCacheTable'
Information on libraryCache performance.
oraDbLibraryCacheEntry row .1.3.6.1.4.1.111.4.1.4.1
LibraryCache information for each Oracle database.
Column Syntax OID
A unique integer for each row of the table.
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.4.1.1
The namespace of the v$librarycache table that this
row relates to.
RFC1213-MIBDisplayString .1.3.6.1.4.1.111.4.1.4.1.2
Number of times the system requests handles to library
objects in this namespace.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.4.1.3
Number of times the handles are already allocated in
the cache.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.4.1.4
Number of times the system issues pin requests
for objects in the cache in order to access them.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.4.1.5
Number of times the objects the system is pinning
are already allocated and initialized in the cache.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.4.1.6
Number of times the library objects have to be reinitialized
and reloaded with data because they have been aged out or
invalidated
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.4.1.7
Number of times that non-persistent library objects
(like shared SQL areas) have been invalidated.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.4.1.8

oraDbLibraryCacheSumTable

table mandatory
.1.3.6.1.4.1.111.4.1.5 · 1 row entry · 6 columns
Uses the oracle variant from /opt/observium/mibs/oracle.
Command help
Walk oraDbLibraryCacheSumTable
/usr/bin/snmpbulkwalk -v2c -c '<community>' -Pud -Ir -OQUs -m 'ORADB-MIB' -M '/opt/observium/mibs/oracle:/opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp' 'udp:<hostname>:161' 'ORADB-MIB::oraDbLibraryCacheSumTable'
Information on library cache performance, summed over all
library caches in a single database instance.
oraDbLibraryCacheSumEntry row .1.3.6.1.4.1.111.4.1.5.1
LibraryCache information, summed over all library caches,
for each Oracle database.
Column Syntax OID
Number of times the system requests handles to library
objects, summed over all library caches in the instance.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.5.1.1
Number of times the handles are already allocated in
the cache, summed over all library caches in the instance.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.5.1.2
Number of times the system issues pin requests
for objects in a cache in order to access them,
summed over all library caches in the instance.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.5.1.3
Number of times the objects the system is pinning
are already allocated and initialized in a cache,
summed over all library caches in the instance.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.5.1.4
Number of times the library objects have to be reinitialized
and reloaded with data because they have been aged out or
invalidated, summed over all library caches in the instance.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.5.1.5
Number of times that non-persistent library objects
(like shared SQL areas) have been invalidated, summed over
all library caches in the instance.
RFC1155-SMICounter
Type Constraints:
range: 0..4294967295
.1.3.6.1.4.1.111.4.1.5.1.6

oraDbSGATable

table mandatory
.1.3.6.1.4.1.111.4.1.6 · 1 row entry · 4 columns
Uses the oracle variant from /opt/observium/mibs/oracle.
Command help
Walk oraDbSGATable
/usr/bin/snmpbulkwalk -v2c -c '<community>' -Pud -Ir -OQUs -m 'ORADB-MIB' -M '/opt/observium/mibs/oracle:/opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp' 'udp:<hostname>:161' 'ORADB-MIB::oraDbSGATable'
Summary information on the System Global Area
oraDbSGAEntry row .1.3.6.1.4.1.111.4.1.6.1
A single entry from the v$sga table
Column Syntax OID
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.6.1.1
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.6.1.2
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.6.1.3
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.6.1.4

oraDbConfigTable

table mandatory
.1.3.6.1.4.1.111.4.1.7 · 1 row entry · 29 columns
Uses the oracle variant from /opt/observium/mibs/oracle.
Command help
Walk oraDbConfigTable
/usr/bin/snmpbulkwalk -v2c -c '<community>' -Pud -Ir -OQUs -m 'ORADB-MIB' -M '/opt/observium/mibs/oracle:/opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp' 'udp:<hostname>:161' 'ORADB-MIB::oraDbConfigTable'
Oracle-specific configuration information global to a database.
oraDbConfigEntry row .1.3.6.1.4.1.111.4.1.7.1
Oracle-specific configuration information.
This table only lists a few
init.ora parameters that are particularly relevant to the
task of monitoring database performance. By giving them
easy-to-use, fixed object-ids, w…
Column Syntax OID
The DB_BLOCK_BUFFERS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.1
The DB_BLOCK_CHECKPOINT_BATCH parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.2
The DB_BLOCK_SIZE parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.3
The DB_FILE_SIMULTANEOUS_WRITES parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.4
The DB_MULTIBLOCK_READ_COUNT parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.5
The DISTRIBUTED_LOCK_TIMEOUT parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.6
The DISTRIBUTED_RECOVERY_CONNECT_HOLD parameter from the
init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.7
The DISTRIBUTED_TRANSACTIONS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.8
The LOG_ARCHIVE_BUFFER_SIZE parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.9
The LOG_ARCHIVE_BUFFERS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.10
The LOG_BUFFER parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.11
The LOG_CHECKPOINT_INTERVAL parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.12
The LOG_CHECKPOINT_TIMEOUT parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.13
The LOG_FILES parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.14
The MAX_ROLLBACK_SEGMENTS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.15
The MTS_MAX_DISPATCHERS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.16
The MTS_MAX_SERVERS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.17
The MTS_SERVERS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.18
The OPEN_CURSORS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.19
The OPEN_LINKS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.20
The OPTIMIZER_MODE parameter from the init.ora file
RFC1213-MIBDisplayString .1.3.6.1.4.1.111.4.1.7.1.21
The PROCESSES parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.22
The SERIALIZABLE parameter from the init.ora file
TruthValue
Type Values:
1true
2false
.1.3.6.1.4.1.111.4.1.7.1.23
The SESSIONS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.24
The SHARED_POOL parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.25
The SORT_AREA_SIZE parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.26
The SORT_AREA_RETAINED_SIZE parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.27
The TRANSACTIONS parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.28
The TRANSACTIONS_PER_ROLLBACK parameter from the init.ora file
Integer32
Type Constraints:
range: -2147483648..2147483647
.1.3.6.1.4.1.111.4.1.7.1.29