|
Oracle Streams STRMMON Monitoring Utility [ID 290605.1]
In this Document
Purpose
Scope and Application
Oracle Streams STRMMON Monitoring Utility
Installation
Usage
Output
Known problems
References
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.4 - Release: 9.2 to 10.2
Information in this document applies to any platform.
On release 11G and onwards STRMMON functionality has been replaced by the Streams Performance Advisor distributed within the Streams product and implemented through DBMS_STREAMS_ADVISOR_ADM PL/SQL package. Please refer to chapter "Monitoring the Oracle Streams Topology and Performance" on "Oracle Streams Concepts and Administration 11g Release 1" guide for further information on the Streams Performace Advisor
strmmon工具适用于oracle9i和10g，在11g中，oracle提供了Streams Performance Advisor来替代strmmon，Streams Performance Advisor通过DBMS_STREAMS_ADVISOR_ADM PL/SQL 实现其功能。
Purpose ***Checked for relevance on 10-Jan-2011***
The purpose of the note is to explain how to install, use and interpret the output of STRMMON utility.
本文的目的旨在说明如何安装，使用strmmon工具，如何理解strmmon工具的输出
Scope and Application STRMMON is a monitoring tool focused on Oracle Streams. Using this tool,Database administrators get a quick overview of the Streams activity occurring within a database.
STRMMON can also be used to report Streams activity on two databases at a time within the same strmmon session.
strmmon工具可以同时监控两个数据库
In releases 9i and 10G Release 1, STRMMON is not a supported tool, as of Oracle 10g Release 2, STRMMON is distributed as in the demo directory of the database distribution code.
在oracle9i和10g1中，默认没有安装strmmon，需要我们单独
下载strmmon压缩包来安装，在10g2中，oracle默认提供strmmon安装文件，位置在$ORACLE_HOME/rdbms/demo
Also note that alternatively and in newer releases of RDA you can get using similar information that STRMMON retrieve by using Streams Monitoring Information module (STM). So you can get this information by running
./rda.sh -vCRP STM or
./rda.sh -vCRP OS DB DBA NET D2PC STC STM
Oracle Streams STRMMON Monitoring Utility
Installation STRMMON is delivered as a zip file that includes an OCI program and make file for use with Oracle releases prior to 10g Release 2.
Click here to download the STRMMON zip file. Change directory to a new directory. If necessary transfer the tar file in BINARY mode. Extract the files from the zip file.
For releases prior to Oracle Database 10g Release 2
Create a directory for the STRMMON files. Extracted the files from the downloaded STRMMON.zip file. Before compiling and linking the strmmon program, make sure that the ORACLE_HOME and LD_LIBRARY_PATH environmental variables are set up appropriately. To compile and link, use the command:
make –f strmmon.mk strmmon
在oracle9i和10g1下，首先我们下载strmmon压缩包，解压后，运行 make -f stmmon.mk strmmon命令，在运行命令前，需要正确设置ORACLE_HOME和LD_LIBRARY_PATH环境变量。
After the program has been compiled and linked, strmmon can be used for monitoring a Streams environment.
NOTE: STRMMON is an OCI program. If you have difficulty using the supplied make file, follow the recommended procedure for compiling and linking OCI programs for your platform. (demo_rdbms.mk in the $ORACLE_HOME/rdbms/demo directory).
The strmmon.mk file identified above is a copy of the demo_rdbms.mk file from the Oracle 9i Database Release 2 software for the Solaris 32-bit platform.
如果使用上面的方式无法编译strmmon（压缩包中的 strmmon 是9i下 solaris 32 平台下demo_rdbms.mk的拷贝），可以采用下面的方法试一试
For Ora |