t The STRMMON output format comes in two formats: default and long.
The default format reports the rate of activity occuring for Streams processes.
The long format provides the detailed information that was available in previous releases of STRMMON. The reporting interval and number of iterations to display are configurable.
The strmmon output begins with a banner line identifying the program parameters and database. This information is followed with a brief description of the major components of the output display.
strmmon工具的首先输出版本信息和格式说明两部分
After this initial information about the program, Strmmon produces a single line of output representing the current status of Oracle Streams after the requested interval for each iteration. For example, if strmmon is invoked with '-interval 3 -count 5’, a line of output will be displayed every 3 seconds. After 5 lines have been displayed (15 seconds), the monitoring will end. .
然后，strmmon每间隔一定时间，输出一次streams的状态信息
Each line is composed of multiple blocks of information dependent on the streams processes configured within the database. These blocks are displayed by a keyword to identify the component followed by the statistics for that particular component. The separator between the components is the '|' symbol.
There are 7 components for Streams: LOG, NET, Cxxx, Qx, PRxx, PSxx and Axxx.
strmmon的输出包含7个
组件：log net cxxx qx prxx psxx axxx
Except for the LOG and NET components, multiple occurrences of each component are possible dependent on the streams processes configured at database.
ARxx (Apply Reader) and ASxx (Apply Server) are subcomponents associated with each Axxx component.
An example of this identifying output is shown below:
% strmmon -interval 3 -count 5 -sysdba
STREAMS Monitor, v 2.5 Copyright
Oracle Corp. 2002, 2005.
Interval = 3, Count=5
Logon= @ ORACLE 10.2.0.2.0
Streams Pool Size = 152M
LOG : 日志信息
NET: 网络信息
Cxxx: capture信息
MEM : % stream pool 信息
PRxx: 接受的message信息
Qx : queue信息
PSxx: propagation信息
Axxx: apply信息
: flow control in effect
: potential bottleneck 潜在的瓶颈
AR: apply reader
AS(n): n number of apply server
:
xx->: database instance name
To connect to multiple databases, the following command can be issued. inst1 and inst2 are the network service names (tnsnames.ora) for each database.
An example of the identifying output for the long report is shown below
链接多个数据库的示例：
% strmmon -interval 1 -count 1 -user sys -passw change_on_install \
-dbname inst1 -user sys -passw change_on_install -dbname inst2 \
-sysdba -long
STREAMS Monitor, v 2.5 Copyright Oracle Corp. 2002, 2005.
Interval = 3, Count=5
Logon=sys@inst1 ORACLE 10.2.0.2.0
Streams Pool Size = 152M
LOG :
NET:
Cxxx:
MEM : %
PRxx: /
Qx : /
PSxx: /
Axxx:
: flow control in effect
: potential bottleneck
AR: apply reader
AS(n): n number of apply serve
:
xx->: database instance name
STREAMS Monitor, v 2.5 Copyright Oracle Corp. 2002, 2005.
Interval = 3, Count=5
Logon=sys@inst2 ORACLE 10.2.0.2.0
Streams Pool Size = 152M
LOG :
NET:
Cxxx:
MEM : %
PRxx: /
Qx : /
PSxx: /
Axxx:
: flow control in effect
: potential bottleneck
AR: apply reader
AS(n): n number of apply serve
:
xx->: database instance name
NOTE: The information about the Streams Pool Size is displayed only for database versions greater than or equal to 10gR1.
LOG
Information about the redo log activity is written in this block.
The first statistic following the LOG: keyword is the current SCN that has been written to the redo log. This number |