RE: (oracle q000) Streams AQ: waiting for time management or cleanup tasks fall out.
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'Joel.Patterson@xxxxxxxxxxx'" <Joel.Patterson@xxxxxxxxxxx>, "oratune@xxxxxxxxx" <oratune@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Jun 2012 10:24:01 -0700
Is your job_queue_processes > 0?
DBSNMP uses AQ as well.
Michael Dinh
Disparity Breaks Automation (DBA)
Confidence comes not from always being right but from not fearing to be wrong -
Peter T Mcintyre
Great minds discuss ideas; average minds discuss events; small minds discuss
people - Eleanor Roosevelt
When any rule or formula becomes a substitute for thought rather than an aid to
thinking, it is dangerous and should be discarded -Thomas William Phelps
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: Thursday, June 21, 2012 10:20 AM
To: oratune@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: (oracle q000) Streams AQ: waiting for time management or cleanup
tasks fall out.
I'm not using data pump at the moment, especially when first starting the
database. I could at any time if that is what you mean by having data pump
configured.
I do not believe I have Streams configured either.
Joel Patterson
Database Administrator
904 727-2546
From: David Fitzjarrell [mailto:oratune@xxxxxxxxx]
Sent: Thursday, June 21, 2012 10:14 AM
To: Patterson, Joel; oracle-l@xxxxxxxxxxxxx
Subject: Re: (oracle q000) Streams AQ: waiting for time management or cleanup
tasks fall out.
If you have Data Pump configured then you're using AQ. Remember that AQ is
reading from and possibly writing to a queue table and if you also have Streams
configured and running the I/O could get heavy.
David Fitzjarrell
From: "Joel.Patterson@xxxxxxxxxxx<mailto:Joel.Patterson@xxxxxxxxxxx>"
<Joel.Patterson@xxxxxxxxxxx<mailto:Joel.Patterson@xxxxxxxxxxx>>
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, June 21, 2012 6:54 AM
Subject: (oracle q000) Streams AQ: waiting for time management or cleanup tasks
fall out.
When first starting a database I get very high USER IO: I used db optimizer to
see what stands out. user 'Unknown', is shown to be consuming IO - it is
connected to Non-SQL Activity with an SQL_ID of 0, and a SQL_ID which is
connected to the Advanced queuing wait event in the subject line.
I am unsure how this wait event or session is connected to the IO. Has anyone
come across this before? Don't use AQ purposely in this DB or others.
Joel Patterson
Database Administrator
904 727-2546
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
