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

From: Tim Gorman <tim_at_evdbt.com>
Date: Thu, 21 Jun 2012 14:37:27 -0600
Message-ID: <4FE38607.3000009_at_evdbt.com>

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_at_crowley.com 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_at_XIFIN.Com]
> Sent: Thursday, June 21, 2012 1:24 PM
> To: Patterson, Joel; oratune_at_yahoo.com; oracle-l_at_freelists.org
> 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

Received on Thu Jun 21 2012 - 15:37:27 CDT