RE: (oracle q000) Streams AQ: waiting for time management or cleanup tasks fall out.
From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 22 Jun 2012 10:29:51 -0700 (PDT)
Message-ID: <1340386191.91716.YahooMailClassic_at_web181201.mail.ne1.yahoo.com>
Joel,
Date: Fri, 22 Jun 2012 10:29:51 -0700 (PDT)
Message-ID: <1340386191.91716.YahooMailClassic_at_web181201.mail.ne1.yahoo.com>
Joel,
Glad to know you found the cause of the problem (accessing sys.aud$). I think I've seen 'Streams AQ:%' events with high I/O related to Oracle working on sys.sys$service_metrics_tab, a table in sysaux tablespace. I have a short note about it at http://yong321.freeshell.org/oranotes/aq_tm_processes.txt
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 22 2012 - 12:29:51 CDT