sdba]
[-long]
[yue@node1 demo]$ ll
total 716
-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:29 strmmon
-rwxr-xr-x 1 yue dba 129998 Aug 16 23:27 strmmon.bak
-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]$ diff strmmon strmmon.bak
从这里可以看出strmmon.mk最后还是通过demo_rdbms.mk来进行编译
Usage There are 7 command line input parameters for STRMMON: interval, count, user, passwd, dbname, sysdba and long.
The first 2 parameters (interval and count) control the sampling rate and the amount of output. The next 4 parameters specify the connect information to the particular Streams database.
Use multiple occurrences of these 4 parameters to monitor multiple databases within the same strmmon command.
Specifying the last parameter (long) displays more detailed information about each process.
When the command strmmon is issued without any parameters, a usage message is displayed:
strmmon的命令格式如下：
% strmmon
Usage: strmmon -interval -count [-user ]
[-passwd ] [-dbname ] [-sysdba]
Parameters
| Parameter Name |
Value Units |
Description |
| -interval |
Seconds |
The interval at which STRMMON will monitor the database. To specify that the sampling rate to be every 3 seconds:
-interval 3
This is a required parameter for strmmon.
采样间隔
? |
| -count |
Number |
The number of iterations to monitor the Streams environment. To specify 5 iterations, use the following: -count 5
This is a required parameter for strmmon.
采样总次数 |
| -user |
Username |
The schema name for logging into the database. Any schema name can be specified. If the SYS schema is specified, additional information is displayed. To specify the SYSTEM schema, use
-user SYSTEM
This parameter should not be specified if logging in as / as sysdba is desired.
-user is an optional parameter for strmmon.
指定登陆用户名，如果不指定，则默认以“/ as sysdba”方式登陆
? |
| -passwd |
password |
The login password for the schema identified with the -user clause. To specify the password for the SYSTEM schema, use
-passwd oracle
This parameter should not be specified if logging in as / as sysdba is desired
-passwd is an optional parameter for strmmon.
登陆密码 |
| -dbname |
Service name |
The connection information or service name from tnsnames.ora for the specific database to be monitored. To specify the connect information for the monitored database, use
-dbname ORCL.WORLD
This is an optional parameter for strmmon.
tnsname.ora文件中的数据库登陆标示
? |
| -sysdba |
? |
This flag indicates that the login role is SYSDBA. This optional parameter is typically used with the SYS schema.
When logging in as / as sysdba, the -user and -passwd parameters are not required
是否以sysdba方式登陆
? |
| -long |
? |
This flag indicates that the more detailed report is desired. This is an optional parameter for STRMMON. By default, only the capture, apply and propagation rates are
displayed.
指定该参数，则输出详细信息
? |
STRMMON have to be used with the Oracle release used for compilation or linking although it can connect to a different release database by using -dbname parameter.
strmmon必须在编译和链接的数据库上运行
Outpu |