Re: (oracle q000) Streams AQ: waiting for time management or cleanup tasks fall out.

If AQ_TM_PROCESSES is set to 10 or above in 10g, please take a look at 
Oracle Support note #393781.1 and bug #5069930 to see if that matches 
your symptoms?


On 6/21/2012 11:30 AM, Joel.Patterson@xxxxxxxxxxx wrote:
> Yes set to 10.
>
> Usually I see DBSNMP as a known username in v$session.  But in any event, I'd 
> like to know what it is doing and why.   Maybe I could let it run all weekend 
> -- except that after an hour or two it begins affecting every other database 
> that shares the SAN.
>
> Joel Patterson
> Database Administrator
> 904 727-2546
>
> -----Original Message-----
> From: Michael Dinh [mailto:mdinh@xxxxxxxxx]
> Sent: Thursday, June 21, 2012 1:24 PM
> To: Patterson, Joel; oratune@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: RE: (oracle q000) Streams AQ: waiting for time management or cleanup 
> tasks fall out.
>
> Is your job_queue_processes > 0?
>
> DBSNMP uses AQ as well.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: