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