个人总结

做logminer时,会出现hang住的现象.此文档中说的hang并没有说明做了些什么操作.
在过去做logminer分析日志时自己也遇到过hang住的情况,当时自己添加了太多的归档日志,机器运行了半天没有反应.cpu也没有消耗,后来一次不添加过多的日志可以顺利分析了.
关于aq_tm_processes. 10.2的reference这样写的

AQ_TM_PROCESSES

Property	Description
Parameter type	Integer
Default value	0
Modifiable	ALTER SYSTEM
Range of values	0 to 10
Basic	No

AQ_TM_PROCESSES enables time monitoring of queue messages. The times can be used in messages that specify delay and expiration properties. Values from 1 to 10 specify the number of queue monitor processes created to monitor the messages. If AQ_TM_PROCESSES is not specified or is set to 0, then the queue monitor is not created.

这个参数具体做什么的不知道.装10201GC的时候,如果install type选的是安装到已有数据中,则需要修改这个AQ_TM_PROCESSES. 个人理解reference解释说AQ_TM_PROCESSES 让监控的queue message时间生效.这些时间在信息被指定delay和expriration时可以用到. AQ_TM_PROCESSES值从1到10,决定了queue monitor进程的数量. 如果AQ_TM_PROCESSES没有设置或者值为0,则queue monitor不会被创建. (queue monitor 还待理解)

这个参google关键字 "oracle queue monitor 解释" 搜到文档 "10g QMON Architecture及AQ_TM_PROCESSES-性能调优" http://www.diybl.com/course/7_databases/oracle/oraclejs/20100628/218885.html

提到Master Note for AQ Queue Monitor Process (QMON) [ID 305662.1] .

文档中解释QMON processes are connected with Oracle Streams, Advanced Queueing (AQ), and a variety of other Database products which monitor and maintain system and user-owned AQ persistent and buffered objects.

Logminer Hang [ID 1101723.1]

		Modified 08-NOV-2011 Type PROBLEM Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later [Release: 10.2 and later ]
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 [Release: 10.2 to 10.2]
Information in this document applies to any platform.

Symptoms

The Logminer session seems to hang after it begins mining only a few files. You cannot find any errors in the alert log nor in trace files.

Alert log only shows where Logminer was manually stopped and restarted.

Cause

aq_tm_processes was explicitly set to 0.

Solution

Set the parameter aq_tm_processes to a value higher than 0.

参考文档: 10g QMON Architecture及AQ_TM_PROCESSES-性能调优 http://www.diybl.com/course/7_databases/oracle/oraclejs/20100628/218885.html
相关metalink文档 Master Note for AQ Queue Monitor Process (QMON) [ID 305662.1] 这个自己查吧.文档太长.

ITPub博客

Logminer Hang