使用ORACLESTREAMSTRMMON监控工具 - 数据库编程

cle Database 10g Release 2

STRMMON is distributed in the rdbms/demo directory on Release 10G release 2.

It is installed when installing "Oracle Database 10G Products" in the Companion CD.

To use the latest version of strmmon in Oracle Database 10g Release 2, archive the existing strmmon.c, strmmon.o, and strmmon files in the $ORACLE_HOME/rdbms/demo directory into a backup location. Then, extract the strmmon.c and the strmmon.html files from the STRMMON zip file into the rdbms/demo directory. Use the existing make file (demo_rdbms.mk) in the demo directory to generate the strmmon executable.
在10g2下，oracle默认为我们提供了strmmon，但是，我们也可以自己来编译，编译方法如下： 1：备份demo下的文件 2：拷贝下载的strmmon下的strmmon.c和strmmon.html文件到demo下 3：使用demo_rdbms.mk来编译strmmon

[yue@node1 demo]$ ll
total 452
-rw-r--r-- 1 yue oinstall    190 Aug  9 14:17 aqxml.conf
-rw-r----- 1 yue oinstall    190 Aug  9 13:58 aqxml.conf.ouibak
-rw-r--r-- 1 yue oinstall  10131 May 14  2009 demo_rdbms32.mk
-rw-r--r-- 1 yue oinstall  10118 Sep 28  2007 demo_rdbms64.mk
-rw-r--r-- 1 yue dba        9877 Aug 16 20:00 demo_rdbms.mk
-rw-r--r-- 1 yue dba      131780 Feb  7  2008 strmmon.c
-rw-r--r-- 1 yue dba       45922 Feb 10  2007 strmmon.htm
-rw-r--r-- 1 yue dba        1308 Aug 23  2004 strmmon.mk
-rw-r--r-- 1 yue dba      186688 Aug 16 20:02 strmmon.o
-rw-r--r-- 1 yue dba       31981 Aug 16 19:59 strmmon.zip
[yue@node1 demo]$ make -f demo_rdbms.mk strmmon
make -f /u01/app/singleoracle/product/11.2.0/db/rdbms/demo/demo_rdbms.mk build EXE=strmmon OBJS=strmmon.o
make[1]: Entering directory `/u01/app/singleoracle/product/11.2.0/db/rdbms/demo'
/usr/bin/gcc -L/u01/app/singleoracle/product/11.2.0/db/lib/ -L/u01/app/singleoracle/product/11.2.0/db/rdbms/lib/ -o strmmon strmmon.o -lclntsh   `cat /u01/app/singleoracle/product/11.2.0/db/lib/sysliblist` -ldl -lm  -lpthread
make[1]: Leaving directory `/u01/app/singleoracle/product/11.2.0/db/rdbms/demo'
[yue@node1 demo]$ ll
total 584
-rw-r--r-- 1 yue oinstall    190 Aug  9 14:17 aqxml.conf
-rw-r----- 1 yue oinstall    190 Aug  9 13:58 aqxml.conf.ouibak
-rw-r--r-- 1 yue oinstall  10131 May 14  2009 demo_rdbms32.mk
-rw-r--r-- 1 yue oinstall  10118 Sep 28  2007 demo_rdbms64.mk
-rw-r--r-- 1 yue dba        9877 Aug 16 20:00 demo_rdbms.mk
-rwxr-xr-x 1 yue dba      129998 Aug 16 23:27 strmmon
-rw-r--r-- 1 yue dba      131780 Feb  7  2008 strmmon.c
-rw-r--r-- 1 yue dba       45922 Feb 10  2007 strmmon.htm
-rw-r--r-- 1 yue dba        1308 Aug 23  2004 strmmon.mk
-rw-r--r-- 1 yue dba      186688 Aug 16 20:02 strmmon.o
-rw-r--r-- 1 yue dba       31981 Aug 16 19:59 strmmon.zip
[yue@node1 demo]$ ./strmmon 
Usage: strmmon -interval  -count  [-user ]
               [-passw ] [-dbname ] [-sysdba]
               [-long]
[yue@node1 demo]$ mv strmmon strmmon.bak
[yue@node1 demo]$ make -f strmmon.mk strmmon
make -f /u01/app/singleoracle/product/11.2.0/db/rdbms/demo/demo_rdbms.mk build EXE=strmmon OBJS=strmmon.o
make[1]: Entering directory `/u01/app/singleoracle/product/11.2.0/db/rdbms/demo'
/usr/bin/gcc -L/u01/app/singleoracle/product/11.2.0/db/lib/ -L/u01/app/singleoracle/product/11.2.0/db/rdbms/lib/ -o strmmon strmmon.o -lclntsh   `cat /u01/app/singleoracle/product/11.2.0/db/lib/sysliblist` -ldl -lm  -lpthread
make[1]: Leaving directory `/u01/app/singleoracle/product/11.2.0/db/rdbms/demo'
[yue@node1 demo]$ ./strmmon -s
Error: option 's' needs a value
[yue@node1 demo]$ ./strmmon 
Usage: strmmon -interval  -count  [-user ]
               [-passw ] [-dbname ] [-sy

使用ORACLESTREAMSTRMMON监控工具(二)