zergduan 发表于 2017-3-6 13:09
你是用v$wait_chain看到的这个现象么?把查询结果和SQL发出来
看看你说的空闲等待是什么?
或者差ASH的 ...
SQL> select t.chk_time,t.chain_signature from tbl_mon_wait_chains t where t.chk_time=to_date('2017-03-06 12:50:01','yyyy-mm-dd hh24:mi:ss')
2;
CHK_TIMECHAIN_SIGNATURE
----------- --------------------------------------------------------------------------------
2017-03-06'rdbms ipc message'
2017-03-06'LNS ASYNC end of log'
2017-03-06'Streams AQ: waiting for messages in the queue'