HP PolyServe Software - Manual (Page 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.