There is very little information about dmstool on the Internet. I also know some usage through usage. The following describes the usage through the help tool:
Description:
This script is a client side tool. Users can use it for collecting DMS metrics from multiple DMS instruments servers.
Usage:
Usage: dmstool -helpdmstool -list [-table] [-delimitor <delimitor>] [-address <[opmn://]host[:port][path],...>]dmstool [-interval <secs>] [-count <num>] [-address <[opmn://]host[:port][path],...>] [-delimitor <delimitor>] <metric> <metric> ...dmstool -table [-interval <secs>] [-count <num>] [-address <[opmn://]host[:port][path],...>] [<table> <table> ...]dmstool -reset [-table] <metric|table> <metric|table> ...dmstool -dump [-interval <secs>] [-count <num>] [-address <[opmn://]host[:port][path],...>] [format=xml|<query>]
What we usually use is to print dump information. Of course, there is also a closely related dmstool-list, that is, to obtain the value of a value ~
Go to the $ ORACLE_HOME directory of your dmstool. Mine is under/opt/Oracle/product/10.1.3.1/oracleas/bin, and then execute
Dmstool
/· Hostname ·/productname: 12506: 6100/productname/default/logpool/poolsize. Value-C 1> ~ /ZY/poolsize
Cat ~ /ZY/poolsize
Tue Feb 14 15:39:15 CST 2012/sor-sys.test.com/OC4J:12506:6100/oc4j/default/logPool/PoolSize.value 0 connections
The value is obtained through dmstool-list ~
/$ ORACLE_HOME/bin/dmstool/$ {hostname}/productname :$ {ajpport}: 6100/productname/default/$ {schema}/poolsize. value-C 1 [connection pool size]
/$ ORACLE_HOME/bin/dmstool/$ {hostname}/productname :$ {ajpport}: 6100/productname/default/$ {schema}/freepoolsize. value-C 1 [idle connection pool size]
The default port 6100 is the OPMN Port ~