Re: What is the ora_q000 process

From: Tim X <timx_at_nospam.dev.null>
Date: Fri, 09 Jan 2009 09:55:46 +1100
Message-ID: <87eizdwgp9.fsf_at_lion.rapttech.com.au>

Chuck <chuckh1958_nospam_at_gmail.com> writes:

> ddf wrote:
>> On Jan 7, 2:34 pm, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
>>> I've got three background processes named ora_q000, ora_q001, and
>>> ora_q003 on a 10.2.0.4 instance. What are they?
>>
>> AQ processes.
>>
>>> The documentation
>>> (http://tinyurl.com/85945h) says nothing about ora_q000 processes, and a
>>> google search didn't turn up anything other than other folks asking the
>>> same question but not getting an answer.
>>
>> Try Metalink.
>>
>>> TIA
>>
>>
>> David Fitzjarrell
>
> So why would I have them if I'm not using advanced queuing? Is Oracle
> using AQ on it's own?
>

Quite likely. Many different Oracle features use AQ udner the hood e.g. dbms_schedule(?) data pump, workflow, advanced streams, rule manager (?) and probably many other areas. Its one area where Oracle does seem to be 'eating its own dog food'.

Tim

-- 
tcross (at) rapttech dot com dot au

Received on Thu Jan 08 2009 - 16:55:46 CST