C Performance Metrics

This appendix lists built-in metrics that can help you analyze Oracle Application Server performance. The metrics fall into several distinct areas, such as Oracle HTTP Server, Oracle Containers for J2EE (OC4J). Each table in this chapter lists the metrics that are included in a corresponding Dynamic Monitoring Services metric table.

This appendix contains:

• Oracle HTTP Server Metrics

• JVM Metrics

• JDBC Metrics

• mod_plsql Metrics

• Oracle Process Manager and Notification Server - OPMN Metrics

• DMS Internal Metrics

C.1 Oracle HTTP Server Metrics

The tables, Table C-1 through Table C-5 describe the Oracle HTTP Server metrics.

Table C-1 describes the HTTP server metrics. The metric table name is ohs_server.

Table C-1 HTTP Server Metrics (ohs_server)

Metric	Description	Unit
busyChildren.value	Number of busy Child processes	processes
childFinish.count	Number of child processes that finish	processes
childStart.count	Number of child processes that start	processes
connection.active	Number of connections currently open	threads
connection.avg	Average time spent servicing HTTP connections	usecs
connection.completed	Number of times an HTTP connection was established.	ops
connection.maxTime	Maximum time spent servicing any HTTP connection	usecs
connection.minTime	Minimum time spent servicing any HTTP connection	usecs
connection.time	Total time spent servicing HTTP connections	usecs
error.count	Number of HTTP errors	count
get.count	Number of GET requests	count
handle.active	Child servers currently in the handle processing phase	threads
handle.avg	Average time spent in module handler	usecs
handle.completed	Number of times the handle processing phase has completed	ops
handle.maxTime	Maximum time spent in module handler	usecs
handle.minTime	Minimum time spent in module handler	usecs
handle.time	Total time spent in module handler	usecs
internalRedirect.count	Number of times a module redirected a request to a new, internal URI	ops
lastConfigChange.value	Time and date configuration was last modified	time
numChildren.value	Total number of processes for request handling	processes
numMods.value	Number of loaded modules	ops
post.count	Number of POST requests	ops
readyChildren.value	Number of processes ready to handle a request	processes
request.active	Child servers currently in the request processing phase	threads
request.avg	Average time required to service an HTTP request	usecs
request.completed	Number of HTTP request completed	ops
request.maxTime	Maximum time required to service an HTTP request	usecs
request.minTime	Minimum time required to service an HTTP request	usecs
request.time	Total time required to service HTTP requests	usecs
responseSize.value	Size of response	bytes

C.1.1 Oracle HTTP Server Child Server Metrics

Table C-2 describes the child server metrics.

The metric table name is ohs_child.

Table C-2 Oracle HTTP Server Child Server Metrics (ohs_child)

Metric	Description	Unit
pid.value	Child`s process identifier
slot.value	Child`s slot identifier
status.value	Current status of child
time.value	Time spent by this child in processing most recent request
url.value	URL of most recent request

C.1.2 Oracle HTTP Server Responses Metrics

The Oracle HTTP Server responses metrics are included in the metric table type ohs_responses. This metric table includes one metric containing the count, number of times the response was generated, for each HTTP response type.

For example, Success_OK_200.count: 28 ops.

C.1.3 Oracle HTTP Server Virtual Host Metrics

Table C-3 shows the Oracle HTTP Server virtual host metrics.

The metrics table type is ohs_vhostSet.

The ohs_virtualHost metric table type contains information on virtual host names and locations, and request and response metrics.

Table C-3 Oracle HTTP Server Virtual Host Metrics (ohs_virtualHost)

Metric	Description	Unit
request.active	Number of requests currently being processed by this host	threads
request.avg	Average time spent processing requests for this virtual host	usecs
request.completed	Number of requests processed by this virtual host	ops
request.maxTime	Maximum time spent processing any single request for this virtual host	usecs
request.minTime	Minimum time spent processing any single request for this virtual host	usecs
request.time	Total time spent processing requests for this virtual host	usecs
responseSize.value	Size of response	bytes
vhostType.value	Type of virtual host

C.1.4 Aggregate Module Metrics

Table C-4 shows the Oracle HTTP Server module metrics.

The metric table type is ohs_module.

Table C-4 Oracle HTTP Server Modules Metrics

Metric	Description	Unit
numMods.value	Number of loaded modules

C.1.5 HTTP Server Module Metrics

There is one set of metrics for each module loaded into the server.

The metric table name is ohs_module.

Table C-5 Oracle HTTP Server Modules/mod_*.c Metrics (ohs_module)

Metric	Description	Unit
decline.count	Number of requests declined	ops
handle.active	Number of requests currently being handled by this module	requests
handle.avg	Average time required for this module	usecs
handle.completed	Number of requests handled by this module	ops
handle.maxTime	Maximum time required for this module	usecs
handle.minTime	Minimum time required for this module	usecs
handle.time	Total time required for this module	usecs

C.1.6 Oracle HTTP Server mod_oc4j Metrics

Table C-6 shows the mod_oc4j Failure Causes metrics. This table represents the categorization of errors that return an INTERNAL_SERVER_ERROR to the client.

The metric table name is mod_oc4j_request_failure_causes.

Table C-6 HTTP Server mod_oc4j Request Failure Causes Metrics

Metric	Description	Unit
IncorrectReqInit.count	The total number of times an internal error occurred. There could be a number of reasons, including: mod_oc4j not finding a connection endpoint, configuration errors, and others.	ops
Oc4jUnavailable.count	The total number of times that an oc4j JVM could not be found to service requests.	ops
UnableToHandleReq.count	The total number of times mod_oc4j declined to handle a request.	ops

Table C-7 shows the mod_oc4j Mount Point metrics. There is one mount point metric table for each mount point specified in mod_oc4j.conf. This table includes a set of metrics for each mount point specified, with each set grouped under the mntPtid. Where id is an integer that is automatically generated during module initialization.

The metric table name is mod_oc4j_mount_pt_metrics.

Table C-7 HTTP Server mod_oc4j Mount Point Metrics

Metric	Description	Unit
Destination.value	Specifies the destination name. For example, with: Oc4jMount /j2ee/* home The Destination.value would be home	String
ErrReq.count	Specifies the total number of requests, both session and non-session, that mod_oc4j failed to route to an OC4J.	ops
ErrReqNonSess.count	Specifies the total number of non session requests that mod_oc4j failed to route to an oc4j process.	ops
ErrReqSess.count	Specifies the total number of session requests that mod_oc4j failed to route to an OC4J process.	ops
Failover.count	Shows the total number of requests that have had a failover (which means that the had an error while talking to a JVM and switched over to another JVM.	ops
Name.value	Specifies the echo of the value specified as the path for Oc4jMount directive in mod_oc4j.conf. DMS changes certain characters, including: '/' and '*' to '_' . To preserve the actual path names specified, an internal table containing a mapping between mntPtid and the actual path name is created during mod_oc4j initialization. For example, with: Oc4jMount /j2ee/* home Name.value would be /j2ee/*	String
NonSessFailover.count	Specifies the total number of failovers for nonsession requests. Shows the number of requests that have had a failover (which means that the request had an error while talking to a JVM and switched over to another JVM.	ops
SessFailover.count	Specifies the total number of failovers for session requests. Shows the number of requests that have had a failover (which means that the request had an error while talking to a JVM and switched over to another JVM.	ops
SucReq.count	Specifies the total number of requests, both session and non-session, that mod_oc4j successfully routed to an OC4J instance.	ops
SucReqNonSess.count	Specifies the total number of non session requests that mod_oc4j successfully routed to an OC4J process.	ops
SucReqSess.count	Specifies the total number of session requests that mod_oc4j successfully routed to an OC4J process.	ops

Table C-8 shows the mod_oc4j Destination Metrics. This table includes a set of metrics for a specific destination. Each destination can have multiple mount points. There is one mntPts subtree for each mount point specified in mod_oc4j.conf.

The metric table name is mod_oc4j_destination_metrics.

Table C-8 HTTP Server mod_oc4j Destination Metrics

Metric	Description	Unit
ErrReq.count	Specifies the total number of requests, both session and non-session, that mod_oc4j failed to route to an OC4J.	ops
ErrReqNonSess.count	Specifies the total number of non session requests that mod_oc4j failed to route to an OC4J process.	ops
ErrReqSess.count	Specifies the total number of session requests that mod_oc4j failed to route to an OC4J process.	ops
Failover.count	Shows the total number of requests that have had a failover (which means that the had an error while talking to a JVM and switched over to another JVM..	ops
JVMCnt.value	Specifies the total number of routable OC4J JVMs that belong to this destination.	Number of JVMs
Name.value	Specifies the echo of the value specified as destination for Oc4jMount directive in mod_oc4j.conf, a single destination may appear several times in mod_oc4j.conf.Example: Oc4jMount /j2ee/* home,oc4jinstance2 Name.value would be home,oc4jinstance2	String
NonSessFailover.count	Specifies the total number of failovers for non session requests.	ops
SessFailover.count	Specifies the total number of failovers.	ops
SucReq.count	Specifies the total number of requests, both session and non-session, that mod_oc4j successfully routed to an OC4J.	ops
SucReqNonSess.count	Specifies the total number of non session requests that mod_oc4j successfully routed to an OC4J process.	ops
SucReqSess.count	Specifies the total number of session requests that mod_oc4j successfully routed to an OC4J process.	ops

C.1.7 Oracle HTTP Server SSL Metrics

Table C-9 describes the OSSL metrics.

The metric table type ohs_ossl.

Table C-9 OHS_OSSL Metrics

Metric	Description	Unit
checkcrl.time	SSL checkcrl was invoked	time
closessl.time	SSL connection was closed	time
connectssl.time	SSL connection was established	time
dataReceive.value	OSSL Data received	kilobytes
dataSent.value	OSSL Data Sent	kilobytes
entercache.time	SSL entercache was invoked	time
getcache.time	SSL getcache was invoked	time
handshake.time	SSL handshake was invoked	time
receive.time	an encrypted message was received	time
receiveErrors.count	an error occurred in receive	ops
send.time	an encrypted message was sent	time
sendErrors.count	an error occurred in send	ops
setfixup.time	SSL setfixup was invoked	time

C.2 JVM Metrics

Table C-10 shows the JVM metrics. There is one set of metrics for each Java process (OC4J) running in the site.

The metric table type is JVM.

Table C-10 JVM Metrics (JVM)

Metric	Description	Unit
activeThreadGroups.value	The number of active thread groups in the JVM	integer
activeThreadGroups.minValue	The minimum number of active thread groups in the JVM	integer
activeThreadGroups.maxValue	The maximum number of active thread groups in the JVM	integer
activeThreads.value	The number of active threads in the JVM	threads
activeThreads.minValue	The minimum number of active threads in the JVM	threads
activeThreads.maxValue	The maximum number of active threads in the JVM	threads
upTime.value	Up time for the JVM	msecs
freeMemory.value	The amount of heap space free in the JVM	kilobytes
freeMemory.minValue	The minimum amount of heap space free in the JVM	kilobytes
freeMemory.maxValue	The maximum amount of heap space free in the JVM	kilobytes
totalMemory.value	The total amount of heap space in the JVM	kilobytes
totalMemory.minValue	The minimum amount of total heap space in the JVM	kilobytes
totalMemory.maxValue	The maximum amount of total heap space in the JVM	kilobytes

C.2.1 JVM Properties Metrics

Oracle Application Server creates a metric to track the value of each Java Property available through a call to System.getProperties() on any Java process. For each Java Property, a metric is created under the /JVM/Properties noun.

For example, each process should have a metric that contains the value of the java.version system property named, /JVM/Properties/java_version.value. The system converts property name components with a period, '.' to '_'.

If, during the life of a process, a property is deleted from the JVM system properties, the corresponding metric is deleted. If the value changes, this is reflected in the metric value the next time it is accessed. If a new property is added to the system properties, a new metric is created.

Note: The JVM Properties metrics are only available for viewing using the Spies text link in AggreSpy, or using the dmstool command to display metrics.

Table C-11 JVM/Properties - JVM System Properties Metrics

Metric	Description	Unit
A metric is created for each system property. Each property name has any of the "." characters in the name replaced with "_".	Contains the value of the Java system property.	String

C.3 JDBC Metrics

The following tables list the Oracle Application Server JDBC metrics.

C.3.1 JDBC Driver Metrics

Table C-12 shows the JDBC driver metrics. There is one set of JDBC Driver metrics per JVM.

The metric table type is JDBC_Driver.

Table C-12 /JDBC/Driver - JDBC_Driver Metrics

Metric	Description	Unit
ConnectionCloseCount.count	Total number of connections that have been closed.	ops
ConnectionCreate.active	Current number of threads creating connections.	ops
ConnectionCreate.avg	Average time spent creating connections.	msecs
ConnectionCreate.completed	Number of times this PhaseEvent has started and ended.	ops
ConnectionCreate.maxTime	Maximum time spent creating connections.	msecs
ConnectionCreate.minTime	Minimum time spent creating connections.	msecs
ConnectionCreate.time	Time spent creating connections.	msecs
ConnectionOpenCount.count	Total number of connections that have been opened.	ops

C.3.2 JDBC Data Source Metrics

Table C-13 shows the JDBC datasource metrics. There is one set of data source metrics per data source.

The metric table type is JDBC_DataSource.

Table C-13 /JDBC/data-source-name - JDBC_Data Source Metrics

Metric	Description	Unit
ConnectionCloseCount.count	Total number of connections that have been closed.	ops
ConnectionCreate.active	Current number of threads creating connections.	ops
ConnectionCreate.avg	Average time spent creating connections.	msecs
ConnectionCreate.completed	Number of times this PhaseEvent has started and ended.	ops
ConnectionCreate.maxTime	Maximum time spent creating connections.	msecs
ConnectionCreate.minTime	Minimum time spent creating connections.	msecs
ConnectionCreate.time	Time spent creating connections.	msecs
ConnectionOpenCount.count	Total number of connections that have been opened.	ops

C.3.3 JDBC Driver Specific Connection Metrics

Table C-14 shows the JDBC driver connection metrics. There is one set of JDBC Connection metrics per connection.

The metric table type is JDBC_Connection.

Table C-14 /JDBC/Driver/CONNECTION - JDBC Driver Connection Metrics

Metric	Description	Unit
CreateNewStatement.avg	Average time spent creating a new statement.	msecs
CreateNewStatement.completed	Number of times a request for a statement failed to be satisfied from the cache.	ops
CreateNewStatement.maxTime	Maximum time spent creating a new statement.	msecs
CreateNewStatement.minTime	Minimum time spent creating a new statement.	msecs
CreateNewStatement.time	Time spent creating a new statement (this does not include the time required to parse the statement. For information on the metric that includes the parse time see Execute.Time in Table C-17).	msecs
CreateStatement.avg	Average time spent getting a statement from the statement cache.	msecs
CreateStatement.completed	Number of times a request for a statement was satisfied from the cache.	ops
CreateStatement.maxTime	Maximum time spent getting a statement from the statement cache.	msecs
CreateStatement.minTime	Minimum time spent getting a statement from the statement cache.	msecs
CreateStatement.time	Time spent getting a statement from the statement cache.	msecs
JDBC_Connection_URL	Url specified for the connection
JDBC_Connection_Username	User name used for the connection
LogicalConnection.value	If this is a physical connection, then this refers to its logical connection, if any.
StatementCacheHit.count	Statement found in cache	ops
StatementCacheMiss.count	Statement not found in cache	ops

C.3.4 JDBC Data Source Specific Connection Metrics

Table C-15 shows the JDBC data source metrics. There is one set of JDBC data source specific connection metrics per data source per connection.

The metric table type is JDBC_Connection.

Table C-15 /JDBC/data-source-name/CONNECTION - JDBC Datasource Connection Metrics

Metric	Description	Unit
CreateNewStatement.avg	Average time spent creating a new statement.	msecs
CreateNewStatement.completed	Number of times a request for a statement failed to be satisfied from the cache.	ops
CreateNewStatement.maxTime	Maximum time spent creating a new statement.	msecs
CreateNewStatement.minTime	Minimum time spent creating a new statement.	msecs
CreateNewStatement.time	Time spent creating a new statement (this time does not include the time required to parse the statement. For information on the metric that includes the parse time see Execute.Time in Table C-18).	msecs
CreateStatement.avg	Average time spent getting a statement from the statement cache.	msecs
CreateStatement.completed	Number of times a request for a statement was satisfied from the cache.	ops
CreateStatement.maxTime	Maximum time spent getting a statement from the statement cache.	msecs
CreateStatement.minTime	Minimum time spent getting a statement from the statement cache.	msecs
CreateStatement.time	Time spent getting a statement from the statement cache.	msecs
JDBC_Connection_Url	Url specified for the connection
JDBC_Connection_Username	User name used for the connection
LogicalConnection.value	If this is a physical connection, then this refers to its logical connection, if any.
StatementCacheHit.count	Statement found in cache
StatementCacheMiss.count	Statement not found in cache

C.3.5 JDBC Connection Source Metrics

Table C-16 shows the JDBC connection source metrics.

The metric table type is JDBC_ConnectionSource.

Table C-16 JDBC Connection Source Metrics

Metric	Description	Unit
CacheFreeSize.count	Number of free slots in the connection cache.	ops
CacheFreeSize.maxValue	Maximum number of free slots in the connection cache.	connections
CacheFreeSize.minValue	Minimum number of free slots in the connection cache.	connections
CacheFreeSize.value	Number of free slots in the connection cache.	connections
CacheGetConnection.active		threads
CacheGetConnection.avg	Average time spent getting a connection from the cache.	msecs
CacheGetConnection.completed	Number of times this PhaseEvent has started and ended.	ops
CacheGetConnection.maxTime	Maximum time spent getting a connection from the cache.	msecs
CacheGetConnection.minTime	Minimum time spent getting a connection from the cache.	msecs
CacheGetConnection.time	Time spent getting a connection from the cache or not.	msecs
CacheHit.count	Number of times a request for a connection has been satisfied from the cache.	ops
CacheMiss.count	Number of times a request for a connection failed to be satisfied from the cache.	ops
CacheSize.value	Number of physical connections in the cache	ops

C.3.6 JDBC Driver Statement Metrics

Table C-17 shows the JDBC statement metrics. There is a set of JDBC statement metrics per connection per statement.

The metric table type is JDBC_Statement.

Note: The JDBC statement metrics are only available for JDBC connections that have enabled statement caching, and set the property oracle.jdbc.DMSStatementCachingMetrics to the value true. When JDBC statement caching is disabled, you can make the JDBC statement metrics available by setting the property oracle.jdbc.DMSStatementMetrics to true. To improve performance and to avoid collecting expensive metrics, by default these properties are both set to false.

Table C-17 /JDBC/Driver/CONNECTION/STATEMENT JDBC Statement Metrics

Metric	Description	Unit
Execute.time	The time this statement has spent executing the SQL including the first fetch and the time required to parse the statement.	msecs
Fetch.time	The time this statement has spent in other fetches.	msecs
SQLText.value	The SQL being executed.

C.3.7 JDBC Data Source Statement Metrics

Table C-18 shows the JDBC statement metrics. There is a set of statement metrics per data source per connection per statement.

The metric table type is JDBC_Statement.

Note: The JDBC statement metrics are only available for JDBC connections that have enabled statement caching and set the property oracle.jdbc.DMSStatementCachingMetrics to the value true. When JDBC statement caching is disabled, you can make the JDBC statement metrics available by setting the property oracle.jdbc.DMSStatementMetrics to true. To improve performance and to avoid collecting expensive metrics, by default these properties are set to false.

Table C-18 /JDBC/data-source-name/CONNECTION/STATEMENT JDBC Statement Metrics

Metric	Description	Unit
Execute.time	The time this statement has spent executing the SQL including the first fetch and the time required to parse the statement.	msecs
Fetch.time	The time this statement has spent in other fetches.	msecs
SQLText.value	The SQL being executed.

C.3.8 JDBC Connection Pool Stats Metrics

Table C-19 shows the JDBC connection pool stats metrics.

The metric table type is jdbc_connection_pool_stats.

Table C-19 JDBC Connection Pool Stats Metrics

Metric	Description	Units
CloseConnectionCount.value	The number of connections closed.	connections
CreateConnectionCount.value	The number of connections created.	connections
FreePoolSize.maxValue	The number of available connections in the pool.	connections
FreePoolSize.minValue	The upper bound of number of available connections in the pool.	connections
FreePoolSize.value	The upper bound of number of available connections in the pool	connections
FreePoolSizeUpperBound.value	The upper bound of number of available connections in the pool	connections
PoolSize.maxValue	The total number of connections in the pool (used and available)	connections
PoolSize.minValue	The total number of connections in the pool (used and available)	connections
PoolSize.value	The total number of connections in the pool (used and available)	connections
PoolSizeLowerBound.value	The lower bound of total number of connections in the pool	connections
PoolSizeUpperBound.value	The upper bound of total number of connections in the pool	connections
UseTime.time	The time spent using a connection	time
WaitTime.time	The time spent waiting for a connection to be available	time
WaitingThreadCount.maxValue	The number of threads waiting for a connection	count
WaitingThreadCount.minValue	The number of threads waiting for a connection	count
WaitingThreadCount.value	The number of threads waiting for a connection	count

C.4 mod_plsql Metrics

This section describes the Oracle Application Server mod_plsql metrics.

Figure C-1, "mod_plsql Metric Tree" shows the structure of the mod_plsql metrics. The tables in this section describe the relevant metrics.

Figure C-1 mod_plsql Metric Tree

Description of "Figure C-1 mod_plsql Metric Tree"

The /modplsql/HTTPResponseCodes Metrics lists the response codes returned by mod_plsql.

The metric table name is modplsql_HTTPResponseCodes. This metric table includes one metric containing the count, number of times the response was generated, for each HTTP response type.

[type=modplsql_HTTPResponseCodes]

For example, the http404.count metric holds a count of the "HTTP 404: Not found" response codes.

Table C-20 lists the set of metrics for the mod_plsql session cache.

The metric table name is modplsql_Cache.

Table C-20 mod_plsql/SessionCache Metrics

Metric	Description	Unit
cacheStatus.value	Status of the cache. This can be either enabled or disabled.	status
newMisses.count	Number of session cache misses (new)	ops
staleMisses.count	Number of session cache misses (stale)	ops
hits.count	Number of session cache hits	ops
requests.count	Number of requests to the session cache	ops

Table C-21 lists the set of metrics for the mod_plsql content cache.

The metric table name is modplsql_ContentCache.

Table C-21 mod_plsql/ContentCache Metrics

Metric	Description	Unit
cacheStatus.value	Status of the cache, either enabled or disabled.
newMisses.count	Number of content cache misses (new)	ops
staleMisses.count	Number of content cache misses (stale)	ops
hits.count	Number of content cache hits	ops
requests.count	Number of requests to the content cache	ops

The SQLErrorGroups metrics show the predefined groupings of SQL errors. For each group, the metrics in Table C-22 are recorded.

The metric table name is modplsql_SQLErrorGroup:

/modplsql/SQLErrorGroups/group [type=modplsql_SQLErrorGroup]

The group is based on the groupings in the Oracle Database Error Messages guide. For example, the metric name Ora24280Ora29249 represents the grouping Ora-24280 to Ora-29249. Each SQL error that occurs as a result of executing a request is put into the appropriate group based on its error code. If you are getting a high number of the same errors, you should investigate what is causing the problem, using the Oracle Database Error Messages guide for further details on the error message.

Table C-22 mod_plsql/SQLErrorGroups Metrics

Metric	Description	Unit
lastErrorDate.value	Date of the last request to cause the SQL error	date
lastErrorRequest.value	Last request to cause the SQL error	url
lastErrorText.value	SQL error text of the last error	error
error.count	Number of errors that have occurred within the group	ops

The LastNSQLErrors statistics show the last 10 SQL errors that have occurred while executing requests. These are updated in a round robin fashion. For each error, the metrics in Table C-23 are recorded.

The metric table name is modplsql_LastNSQLError:

/modplsql/LastNSQLErrors/<SQL Error Slot> [type=modplsql_LastNSQLError]

If you are getting a large number of the same errors, you should investigate what is causing the problem. Refer to the Oracle Database Error Messages guide for further details of the error represented by the errorText.value metric.

Table C-23 mod_plsql/LastNSQLErrors Metrics

Metric	Description	Unit
errorDate.value	Date the request caused the SQL error	date
errorRequest.value	Request causing the SQL error	url
errorText.value	SQL error text	error

Table C-24 lists the set of metrics for the Non-SSO connection pool.

The metric table name is modplsql_DatabaseConnectionPool:

/modplsql/NonSSOConnectionPool [type=modplsql_DatabaseConnectionPool]

Table C-24 mod_plsql/NonSSOConnectionPool Metrics

Metric	Description	Unit
connFetch.maxTime	Maximum time to fetch a connection from the pool	usecs
connFetch.minTime	Minimum time to fetch a connection from the pool	usecs
connFetch.avg	Average time to fetch a connection from the pool	usecs
connFetch.active	Child servers currently in the pool fetch phase	threads
connFetch.time	Total time spent fetching connections from the pool	usecs
connFetch.completed	Number of times a connection has been requested from the pool	ops
newMisses.count	Number of connection pool misses (new)	ops
staleMisses.count	Number of connection pool misses (stale)	ops
hits.count	Number of connection pool hits	ops

Table C-25 lists the set of metrics for the request owner connection pool.

The metric table name is modplsql_DatabaseConnectionPool:

/modplsql/RequestOwnerConnectionPool [type=modplsql_DatabaseConnectionPool]

Table C-25 mod_plsql/RequestOwnerConnectionPool Metrics

Metric	Description	Unit
connFetch.maxTime	Maximum time to fetch a connection from the pool	usecs
connFetch.minTime	Minimum time to fetch a connection from the pool	usecs
connFetch.avg	Average time to fetch a connection from the pool	usecs
connFetch.active	Child servers currently in the pool fetch phase	threads
connFetch.time	Total time spent fetching connections from the pool	usecs
connFetch.completed	Number of times a connection has been requested from the pool	ops
newMisses.count	Number of connection pool misses (new)	ops
staleMisses.count	Number of connection pool misses (stale)	ops
hits.count	Number of connection pool hits	ops

Table C-26 lists the set of metrics for the super user connection pool.

The metric table name is modplsql_DatabaseConnectionPool:

/modplsql/SuperUserConnectionPool [type=modplsql_DatabaseConnectionPool]

Table C-26 mod_plsql/SuperUserConnectionPool Metrics

Metric	Description	Unit
connFetch.maxTime	Maximum time to fetch a connection from the pool	usecs
connFetch.minTime	Minimum time to fetch a connection from the pool	usecs
connFetch.avg	Average time to fetch a connection from the pool	usecs
connFetch.active	Threads currently in the pool fetch phase	threads
connFetch.time	Total time spent fetching connections from the pool	usecs
connFetch.completed	Number of times a connection has been requested from the pool	ops
newMisses.count	Number of connection pool misses (new)	ops
staleMisses.count	Number of connection pool misses (stale)	ops
hits.count	Number of connection pool hits	ops

C.5 Oracle Process Manager and Notification Server - OPMN Metrics

This sections lists the Oracle Process Manager and Notification Server (opmn) metrics.

This section includes the following:

• OPMN_PM Metric Table

• OPMN_OC4J_PROC Table

• OPMN_HOST_STATISTICS Metric Table

• OPMN_IAS_INSTANCE Metric Table

• OPMN_IAS_COMPONENT Table

• OPMN ONS Metrics

• OPMN_APPCTX Table

C.5.1 OPMN_PM Metric Table

The opmn_pm metric table is the root of the process manager subtree for the OPMN DMS metrics. The metrics in this metric table contain statistics about OPMN requests. An OPMN request is a command that has been issued to OPMN from a client, for example DCM, to perform an operation on one or more OPMN managed processes.

Requests can have one of three possible results:

• Success – success means OPMN handles the request successfully.

• Partial Success – partial Success means OPMN only handles part of the request successfully. For example, if a client wants OPMN to start three OC4J processes, and only two are successfully started, the request result is partial success.

• Failure – failure means the request fails.

Table C-27 shows the metric table type opmn_pm.

Table C-27 OPMN_PM Metrics

Metric	Description	Unit
jobWorkerQueue.value	Specifies the number of jobs in the OPMN worker queue	ops
lReq.count	Specifies the number of local HTTP requests which OPMN handles	ops
procDeath.count	Specifies the number of processes which die after the process manager starts them	ops
procDeathReplace.count	Specifies the number of processes which are restarted after the process manager detects they are dead	ops
reqFail.count	Specifies the number of HTTP requests which fail	ops
reqPartialSucc.count	Specifies the number of HTTP requests which partially succeed	ops
reqSucc.count	Specifies the number of HTTP requests which succeed	ops
rReq.count	Specifies the number of remote HTTP requests which OPMN handles	ops
workerThread.value	Specifies the number of worker threads	threads

C.5.2 OPMN_OC4J_PROC Table

Table C-28 shows the OPMN OC4J proc metrics that provides information on the OC4J process.

The metric table type is opmn_oc4j_proc.

Table C-28 OPMN_OC4J_proc Metrics

Metric	Description	Unit
oc4jinstance.value
oc4jIsland.value	This is a backward compatibility metric.

C.5.3 OPMN_HOST_STATISTICS Metric Table

The OPMN host statistics metric table provides information on the host running the OPMN process.

Table C-29 shows the metric table type opmn_host_statistics.

Table C-29 OPMN_HOST_STATISTICS Metrics

Metric	Description	Unit
cpuIdle.value	Specifies the number of milliseconds the cpu(s) have been idle since an unspecified time.	milliseconds
freePhysicalMem.value	Specifies the amount of free physical memory on the host machine.	kilobytes
numProcessors.value	Specifies the number of processors available on the host machine.	integer
timestamp.value	Specifies the time that host statistics are taken. The timestamp is the number of milliseconds from an unspecified time.	milliseconds from an unspecified time
totalPhysicalMem.value	Specifies the total physical memory available on the host machine.	kilobytes

C.5.4 OPMN_IAS_INSTANCE Metric Table

The OPMN IAS instance subtree shows the Oracle Application Server instance node name.

Table C-30 shows the metric table type opmn_ias_instance.

Table C-30 OPMN_IAS_INSTANCE Metrics

Metric	Description	Unit
iasCluster.value	Specifies the Oracle Application Server cluster name for the Oracle Application Server instance.	String

C.5.5 OPMN_IAS_COMPONENT Table

The OPMN IAS component subtree represents an Oracle Application Server component. The OPMN IAS component subtree includes several metric tables containing component information.

Table C-31 shows the metric table type opmn_process_type.

Table C-31 OPMN_PROCESS_TYPE Metrics

Metric	Description	Unit
moduleId.value	Specifies the values of attribute module-IDs, as specified in the process-type tag in the opmn.xml configuration file.	String

Table C-32 shows the metric table type opmn_process_set.

Table C-32 OPMN_PROCESS_SET Metrics

Metric	Description	Unit
numProcConf.value	Specifies the number, or maximum number, of processes configured for this process set.	String (integer)
numProcs.value	Number of process that exist for this process set
IsService.value	Process set is configured as a service	String
reqFail.count	Specifies the number of HTTP requests which fail for this process set.	ops
reqPartialSucc.count	Specifies the number of HTTP requests which partially succeed for this process set.	ops
reqSucc.count	Specifies the number of HTTP requests which succeed for this process set	ops
restartOnDeath.value	Specifies whether, when a process dies, OPMN should restart the process.	String (boolean)

Table C-33 shows the metric table type opmn_process.

Table C-33 OPMN_PROCESS Metrics

Metric	Description	Unit
cpuTime.value	Shows the amount of CPU time used by the process.	CPU msecs
heapSize.value	Shows the heap size of the process.	Kilobytes
iasCluster.value	Shows the Oracle Application Server cluster name for the process	String
iasInstance.value	Shows the Oracle Application Server instance name for the process	String
indexInSet.value	Shows the process index in the process set. This value is only valid for OPMN managed processes, for OPMN unmanaged processes, this value has no meaning, and the value is always 0.	String (integer)
memoryUsed.value	The amount of memory used by the process. This metric is calculated in an operating system specific manner. On UNIX, this is the process image memory used value. This is all the memory in use by the process. On Windows, this is the working set memory used value. This is the same value that is reported by the Task Manager under the mem usage column. The working set is the set of memory pages touched recently by the threads in the process. If free memory in the system is over a certain threshold, pages are left in the working set of a process, even if they are not in use. When free memory falls below a certain threshold, pages are trimmed from the working sets. If needed, pages are soft-faulted back into the working set before they leave main memory.
pid.value	The process ID for the process.
privateMemory.value	The private memory of the process.	Kilobytes
sharedMemory.value	The shared memory for the process	Kilobytes
startTime.value	The start time of the process.	msecs
status.value	The status of the process. The status can have the following values: NONE – New process slot, no operations have been applied yet (no status). Init – process has been started, opmn is waiting for initialization to complete. Alive – process is fully started. Stop – process stop operation is in progress. Stopped – process has been fully stopped. Bounce – non-terminating process restart is in progress. Restart – process stop operation is in progress, prior to a new start being issued. InitFail – failure before init timeout reached, a stop and start will be attempted in the retry limit has not been reached. BounceFail – non-terminating process restart failed, as stop and start will be attempted if the retry limit has not been reached.	String
type.value	The type of the process. See Table C-31 for information on process types.
uid.value	The OPMN assigned ID for the process.
upTime.value	The uptime for the process.	msecs

Table C-34 shows the metric table type opmn_connect.

Table C-34 OPMN_CONNECT Metrics

Metric	Description	Unit
desc.value	Shows the port description, if available	String
host.value	Shows the host name	String (host name)
protocol.value
port.value	Shows the port number	String (port number)

C.5.6 OPMN ONS Metrics

The Oracle Process Manager and Notification Server ONS subtree contains Oracle Notification System (ONS) information.

Table C-35 shows the metric table type opmn_ons.

Table C-35 OPMN_ONS Metrics

Metric	Description	Unit
notifProcessed.value	The number of notifications processed by ONS.	ops
notifProcessQueue.value	The number of notifications in the process queue.	ops
notifReceived.value	The number of notifications received by ONS.	ops
notifReceiveQueue.value	The number of notifications in the receive queue.	ops
workerThread.value	The number of worker threads.	String (threads)

Table C-36 shows the local_port metrics. The ../ons/local_port subtree shows information about the ONS local port.

The metric table type is opmn_connect

Table C-36 OPMN ONS LOCAL_PORT Metrics

Metric	Description	Unit
desc.value	Port description	String
host.value	Host name	String
port.value	Port number	String

Table C-37 shows the remote_port metrics. The ../ons/remote_port subtree shows information about the ONS remote port.

The metric table type is opmn_connect

Table C-37 OPMN ONS REMOTE_PORT Metrics

Metric	Description	Unit
desc.value	Port description	String
host.value	Host name	String
port.value	Port number	String

Table C-38 shows the request_port metrics. The ../ons/request_port subtree shows information about the ONS request port.

The metric table type is opmn_connect

Table C-38 OPMN ONS REQUEST_PORT Metrics

Metric	Description	Unit
desc.value	Port description	String
host.value	Host name	String
port.value	Port number	String

Table C-39 shows the opmn_ons_topo_entry metrics.

Table C-39 OPMN ONS TOPO Entry Metrics

Metric	Description	Unit
protocol.value	ons protocol version
port.value	port value
ip.value	ip address

C.5.7 OPMN_APPCTX Table

Table C-40 shows the opmn_appctx metrics.

Table C-40 OPMN APPCTX Metrics

Metric	Description	Unit
rtid.value
routable.value
state.value

C.6 DMS Internal Metrics

Table C-41 shows the DMS internal clock metrics.

Table C-41 DMS-Internal Clock Metrics

Metric	Description	Unit
logicalTime.value	The current time as measured with the DMS clock.	ticks
measuredFrequency.value	Number of clock ticks per second - measured.	ticks
measuredResolution.value	Time between ticks as measured with this clock.
name.value
overheadPerCall.value	The average duration of a call to get the time with this clock.
reportedFrequency.value	The number of ticks per second the clock time is reported in.	ticks
requestedUnits.value	The string description of the units that times are reported in.

Table C-42 shows the DMS internal log metrics.

Table C-42 DMS-Internal Log Metrics

Metric	Description	Unit
initLogging.count		ops
messagesLogged.count		ops
status.value

Table C-43 shows the DMS internal measurement metrics.

Table C-43 DMS-Internal Measurement Metrics

Metric	Description	Unit
createNoun.count		ops
createSensor.count		ops
destroyNoun.count		ops
destroySensor.count		ops
lastTreeNodeID.value
sampleMetric.count		ops
sensorWeight.value
treeNodes.maxValue
treeNodes.value

Table C-44 shows the DMS internal collector metrics.

Table C-44 DMS-Internal Collector Metrics

Metric	Description	Unit
logger.count		ops
logger.logged		ops
responseGenerateTime.active		threads
responseGenerateTime.avg
responseGenerateTime.completed
responseGenerateTime.maxActive
responseGenerateTime.maxTime
responseGenerateTime.minTime
responseGenerateTime.time

Table C-45 shows the DMS internal transtrace metrics.

Table C-45 DMS-Internal Transtrace Metrics

Metric	Description	Unit
expireMessages.avg
expireMessages.completed
expireMessages.maxActive
expireMessages.maxTime
expireMessages.minTime
expireMessages.time
messageCount.value
pendingMessageCount.value
s_debugEnabled.value
s_dumpEnabled.value
s_ecidEnabled.value
s_transTraceEnabled.value
storeSize.value