|Oracle SNMP Support Reference Guide
Part Number A88768-01
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.
Abstract Syntax Notation One. The notation used to define MIB variables.
An administrative file that is required to start and run a database system. The control file records the physical structure of the database.
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.
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)).
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.
See V$ table.
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.
See Oracle Names.
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.
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.
A memory structure containing shared SQL and PL/SQL areas. The library cache is one of three parts of the shared pool.
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.
A platform, such as a UNIX server, on which objects to be monitored or managed reside.
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.
A software application that can be integrated with a management framework to accomplish more specialized network or database tasks.
A software package used to view and react to information retrieved using the SNMP protocol. See also management application.
A node from which objects are monitored or managed using the SNMP protocol. Also known as management console, management system or managing node.
A process that accepts queries from the management framework and communicates with the application in order to answer the query.
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.
This product is no longer supported past SQL* Net release 2.3. See Oracle Connection Manager.
See Oracle Names.
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.
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.
See object identifier.
The portion of a MIB tree that is specific to a given entity. The subtree for the Oracle enterprise is 126.96.36.199.4.1.111. All of the variables in the Oracle MIBs begin with this OID subtree. Also called root OID.
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.
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.
A product that provides a directory service, by making database address and database link information available to all nodes throughout the network.
The relational database management systems (RDBMS) developed and sold by Oracle Corporation. These RDBMS includes the database that stores information, as well as the server software that accesses and manipulates that information.
Execution of an item in the library cache.
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.
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.
As defined in RFC 1565 (the standard RDBMS MIB) an independent entity that provides access to one or more databases.
See Shared Global Area.
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.
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.
A configuration file for a managed node. SNMP.ORA contains a list of parameters that are read when an Oracle subagent is started.
A process that receives queries for a particular application from the master agent, and sends the answers back to the master agent.
See Shared Global Area.
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.
The dynamic performance table containing database information from the control file.
The dynamic performance table containing file read/write statistics for an Oracle7 database. Some of the variables in the oraDbDataFileTable of the private Oracle Database MIB are retrieved directly from a single column of V$FILESTAT .
The dynamic performance table containing information on the state of the current instance.
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.
The dynamic performance table containing information on license limits.
The dynamic performance table containing measures of all data dictionary activity since the most recent instance startup.
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.
The dynamic performance table containing summary information on the System Global Area of an Oracle7 or Oracle8 database. The values of each variable in the oraDbSGATable of the Oracle Private Database MIB are retrieved directly from a corresponding variable in V$SGA.
The dynamic performance table containing detailed information on the System Global Area of an Oracle7 or Oracle8 database. Values for each variable in the oraDbSGAStatTable of the private Oracle Database MIB are retrieved directly from a corresponding variable in V$SGASTAT.
The dynamic performance table containing the current system-wide 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.
The dynamic performance table containing version numbers of core library components in the Oracle Server. See also, library.