Hp PolyServe Software Bedienungsanleitung PDF herunterladen (Seite 8)

Advanced I/O Monitoring 5

Environment variables are passed through the lsnrctl process to the listener

daemons. Hence, before starting a listener for the

PROD database on a given node,

set the

$ORACLE_SID and $MXODM_DBNAME environment variables. The

following example depicts a session starting a listener process that will accept a

connect request to access the

PROD database through the PROD1 instance. All

activity by server processes begat of this listener will be accounted for

accordingly.

Note that this requirement insists that specific listeners be configured to service

connects to each database on a given node. Instances started with the srvctl

command need to use the built-in method for passing environment variables.

That is, if a database Instance is not started with sqlplus (where

MXODM_DBNAME is set in the environment), and instead srvctl is used, the

MXODM_DBNAME environment variable can be passed to the Instance

background processes using the -t option of the srvctl command. For instance, the

following example will cause

MXODM_DBNAME to be set to “PROD” in any

Instance accessing the

PROD database. As such, this is a central point for setting

the environment for all nodes in the cluster.

$ srvctl setenv database -d PROD -t MXODM_DBNAME=PROD

You may also want to set the MxODM enviroment variable MXODM_APPNAME.

This environment variable offers additional monitoring functionality. It must be

passed to Oracle processes in the same manner as

$MXODM_DBNAME.

$MXODM_APPNAME is essentially a free-form variable. An example of its use

would be to facilitate the monitoring of a specific application module as opposed

to all of the activity within a database. For instance, prior to executing a program

that performs General Ledger activity,

$MXODM_APPNAME could be set to GL,

while

$MXODM_DBNAME might be FIN. Other sessions accessing the FIN

database using an Accounts Payable program might set $

MXODM_APPNAME to

AP. As such, monitoring I/O with the -D option set to FIN will report the

aggregate activity of all processes acessing FIN, but using mxodmstat with the -A

option set to GL will report the portion of FIN activity that is specific to the

processes that have

MXODM_APPNAME set to GL.

1 2 3 4 5 6 7 8 9 10 11 12 13 14

Keine Kommentare

Hp PolyServe Software Bedienungsanleitung Seite 8