Avg
%TimeTotal Waitwait Waits
Event
Waits-outsTime (s)(ms)/txn
---------------------------- -------------- ------ ----------- ------- ---------
SQL*Net message from client 273,700 .042,193 15443.6
Streams AQ: waiting for mess
4,713 96.620,6324378 0.8
Streams AQ: qmn coordinator 5,307 46.510,5481988 0.8
LogMiner: wakeup event for b 43,923 20.910,548 240 7.0
Streams AQ: qmn slave idle w
3,000 .010,5453515 0.5
LogMiner: wakeup event for p 18,937 47.910,545 557 3.0
virtual circuit status
360100.010,494 29150 0.1
Streams AQ: waiting for time
111 60.4 9,473 85345 0.0
LogMiner: client waiting for 12,986 41.4 6,412 494 2.1
class slave wait
7100.0
344882 0.0
我收集了3个小时的AWR报告, SQL*Net message from client参数是不是很有问题,我不敢确定??
|