Veritas Storage Foundation 5.1 SP1 for Oracle RAC Administrator"s Guide (5900-1512, April 2011)

Displays the statistics for a database process. You need to specify
the process ID of the process
-p pid
Displays the statistics for a database. Specify more than one
database when you want to compare database traffic between
multiple databases.
-d db1 [db2]
Indicates the period of time in seconds over which LMX statistics
is gathered for a database .
The default value is 0.
interval
Indicates the number of times LMX statistics is gathered for a
database.
The default value is 1.
count
Table 2-1 lists the usage of the command in various scenarios.
Table 2-1
Using lmxdbstat utility to view LMX traffic for databases
CommandScenario
# lmxdbstat
To view the LMX traffic
for all databases
# lmxdbstat -d db_name
Note: Make sure that LMX statistics collection is enabled,
otherwise the command fails with the error "LMX stats collection
not enabled.". Run the following command to enable LMX
statistics collection:
# lmxdbstat -z 1
To view the LMX traffic
for a particular database
instance
# lmxdbstat -d db_name1 db_name2
To compare the traffic
between multiple
databases
# lmxdbstat -p pid
Note: Make sure that LMX statistics collection is enabled,
otherwise the command fails with the error "LMX stats collection
not enabled". Run the following command to enable LMX
statistics collection:
# lmxdbstat -z 1
To view the LMX traffic
for a particular database
process
83Administering SF Oracle RAC and its components
Administering SF Oracle RAC