Glossary

Agent

A process on a managed node that is responsible for all SNMP transactions on that node. The agent accepts requests from the management station and answers them by returning data. It also initiates traps when exceptional conditions are detected.

ASN.1

Abstract Syntax Notation One. The notation used to define MIB variables.

Control File

An administrative file that is required to start and run a database system. The control file records the physical structure of the database.

DBA_DATA_FILES

A data dictionary view that displays information about database files. Fields in DBA_DATA_FILES are used to retrieve the value of the rdbmsDbInfoSizeAllocated variable and derive the values of the rdbmsDbInfoSizeAllocated and rdbmsDbInfoSizeUsed variable (in Oracle's implementation of the standard RDBMS MIB (RFC 1565)). Also, some of the variables in the oraDbDataFileTable of the private Oracle Database MIB correspond directly to a single column of DBA_DATA_FILES.

DBA_FREE_SPACE

A data dictionary view that displays information about free extents in all tablespaces. DBA_FREE_SPACE is used to derive the value of the rdbmsDbInfoSizeUsed variable (in Oracle's implementation of the public RDBMS MIB (RFC 1565)).

DBA_TABLESPACES

The dynamic performance table containing measures of tablespace activity for an Oracle database since the last instance startup. Values for each variable in the oraDbTablespaceTable of the Oracle Private Database MIB are retrieved directly from a corresponding variable in DBA_TABLESPACES.

INIT.ORA Configuration File

A database system file containing a list of parameters that are read when the database system is started. The parameters identify the database and control system wide resources. By affecting the size of the SGA, they also impact the performance of the instance. Values for each variable in the oraDbConfigTable of the private Oracle Database MIB are retrieved directly from a corresponding parameter in INIT.ORA.

Instance

As defined for the Oracle Server, A system global area (SGA) and the Oracle background processes constitute an Oracle instance. Every time a database is started, a system global area is allocated and Oracle background processes are started. The SGA is deallocated when the instance shuts down.

Library

A collection of one or more PL/SQL program units that are stored together in a file or database, and that can be referenced by several displays at once.

Library Cache

A memory structure containing shared SQL and PL/SQL areas. The library cache is one of three parts of the shared pool.

Listener

The listener is a separate process that resides on the server whose responsibility is to listen for incoming client connection requests and manage the traffic to the server. The Listener is a component of Oracle Net, Oracle's remote data access product.

Managed Node

A platform, such as a UNIX server, on which objects to be monitored or managed reside.

Managed Object

Any entity, device, node, such as a LAN server, gateway, or client application, that can be queried by a management station for its current status.

Management Application

A software application that can be integrated with a management framework to accomplish more specialized network or database tasks.

Management Framework

A software package used to view and react to information retrieved using the SNMP protocol.

Management Station

A node from which objects are monitored or managed using the SNMP protocol. Also known as management console, management system or managing node.

Master Agent

A process that accepts queries from the management framework and communicates with the application in order to answer the query.

MIB

Management Information Base. The collection of variables that can be queried to describe attributes of an object, such as the use, performance, and initialization parameters of a database server, for example.

Network Services MIB

A public MIB (RFC 1565) that contains generic variables designed to apply to all types of network service applications. Oracle has implemented those variables of this MIB that are relevant to the Oracle Server, the Oracle Connection Manager, and the Oracle Net Services products.

Object Identifier (OID)

A sequence of elements, as specified by the SNMP standard (RFC 1442), that uniquely identifies each object. An object identifier (OID) is a sequence of elements that indicates a hierarchical organization of identifiers.

OID Subtree

The portion of a MIB tree that is specific to a given entity. The subtree for the Oracle enterprise is 1.3.6.1.4.1.111. All of the variables in the Oracle MIBs begin with this OID subtree. Also called root OID.

Oracle Connection Manager

A router through which a client connection request may be sent either to its next hop or directly to the database server. Clients who route their connection requests through an Oracle Connection Manager can then take advantage of the session multiplexing, access control, or protocol conversion features configured on that Oracle Connection Manager.

Oracle Database MIB

This private MIB serves to extend the functionality of the public RDBMS MIB. The Oracle Database MIB contains additional RDBMS statistics that are specific to the Oracle server architecture.

Oracle Server

The relational database management systems (RDBMS) developed and sold by Oracle. These RDBMS includes the database that stores information, as well as the server software that accesses and manipulates that information.

Oracle SNMP Peer Encapsulator

Oracle SNMP Peer Encapsulator is a mechanism that can connect any third-party SNMP agents to Oracle SNMP Peer Master Agent.

Oracle SNMP Peer Master Agent

A process that acts as a primary interface between the Network Manager and the subagents. Sometimes, Oracle SNMP Peer Master Agent communicates directly with the elements to be managed rather than communicating with the subagents.

Pin

Execution of an item in the library cache.

RDBMS MIB

A proposed standard MIB for relational databases that has been defined by the IETF Working Group. This MIB allows for database discovery, identification of the database, and characterization of database size and activity level.

Registration

The method by which a subagent, acting on behalf of a managed object, such as a listener or the Oracle server, notifies a master agent of two things: first, that it will accept requests from the master agent for information, and second, the list of items (the MIB) for which it will provide information.

Server

As defined in RFC 1565 (the standard RDBMS MIB) an independent entity that provides access to one or more databases.

Shared Global Area or System Global Area (SGA)

The shared segment containing temporary data caches used by the Oracle server during database operation. The SGA is initialized when the server is started, and unavailable when the server is not running. Also known as System Global Area.

Shared Pool

The portion of the SGA, created on instance startup, that contains shared memory constructs such as shared SQL areas. A shared SQL area is required to process every unique SQL statement submitted to a database. A single shared SQL area is used by multiple applications that issue the same statement, leaving more shared memory for other uses.

SNMP_RO.ORA/SNMP_RW.ORA

Configuration files for a managed node. They contain a list of parameters that are read when an Oracle subagent is started.

Subagent

A process that receives queries for a particular application from the master agent, and sends the answers back to the master agent.

V$ Table

A generic term for a virtual table which allows the user to access memory structures within the SGA. V$ tables can be used to monitor the performance of processes of an Oracle instance. These tables are also called dynamic performance tables, because they are continuously updated while a database is open and in use. The values of many private Oracle Database MIB variables are retrieved directly from corresponding variables in V$ tables.

V$DATABASE

The dynamic performance table containing database information from the control file.

V$FILESTAT

The dynamic performance table containing file read/write statistics for an Oracle database (version 7). Some of the variables in the oraDbDataFileTable of the private Oracle Database MIB are retrieved directly from a single column of V$FILESTAT.

V$INSTANCE

The dynamic performance table containing information on the state of the current instance.

V$LIBRARYCACHE

The dynamic performance table containing measures of all library cache activity since the most recent instance startup. Values for each variable in the oraDbLibraryCacheTable of the private Oracle Database MIB are retrieved directly from a corresponding variable in V$LIBRARYCACHE.

V$LICENSE

The dynamic performance table containing information on license limits.

V$ROWCACHE

The dynamic performance table containing measures of all data dictionary activity since the most recent instance startup.

V$SESSTAT

The dynamic performance table containing the current statistics on total memory used for each current session. In the multi-threaded server architecture, Oracle stores session information in the shared pool, rather than in the memory of user processes. While no variables in the private Oracle Database MIB correspond directly to those in V$SESSTAT, V$SYSSTAT is derived from V$SESSTAT. See also V$SYSSTAT.

V$SGA

The dynamic performance table containing summary information on the System Global Area of an Oracle database (version 7 or version 8). The values of each variable in the oraDbSGATable of the Oracle Private Database MIB are retrieved directly from a corresponding variable in V$SGA.

V$SGASTAT

The dynamic performance table containing detailed information on the System Global Area of an Oracle database (version 7 or 8). Values for each variable in the oraDbSGAStatTable of the private Oracle Database MIB are retrieved directly from a corresponding variable in V$SGASTAT.

V$SYSSTAT

The dynamic performance table containing the current systemwide. value for each variable in V$SESSTAT. Values for each variable in the oraDbSysTable of the private Oracle Database MIB are retrieved directly from a corresponding variable in V$SYSSTAT.

V$VERSION

The dynamic performance table containing version numbers of core library components in the Oracle Server.