What is the ora_q000 process

Chuck

unread,

Jan 7, 2009, 3:34:19 PM1/7/09

to

I've got three background processes named ora_q000, ora_q001, and
ora_q003 on a 10.2.0.4 instance. What are they? 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.

TIA

ddf

unread,

Jan 7, 2009, 3:40:40 PM1/7/09

to

On Jan 7, 2:34 pm, Chuck <chuckh1958_nos...@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

Michel Cadot

unread,

Jan 7, 2009, 3:44:05 PM1/7/09

to

"Chuck" <chuckh19...@gmail.com> a écrit dans le message de news: fl89l.3799$BC4....@nwrddc02.gnilink.net...

There are job queue processes.
Number is defined by job_queue_processes parameter.

Regards
Michel

Chuck

unread,

Jan 7, 2009, 5:14:32 PM1/7/09

to

I thought they were j000 processes.

Chuck

unread,

Jan 7, 2009, 5:19:12 PM1/7/09

to

So why would I have them if I'm not using advanced queuing? Is Oracle
using AQ on it's own?

The reason I'm asking is because yesterday one of our dba's dropped a
tablespace with a 30g datafile in it, them manually rm'ed the file from
the OS (Solaris 10). The space never got released so we went looking for
a process that might have had the file open. We found it was still
opened by ora_q001.

ddf

unread,

Jan 8, 2009, 10:10:35 AM1/8/09

to

On Jan 7, 4:19 pm, Chuck <chuckh1958_nos...@gmail.com> wrote:
> ddf wrote:
> > On Jan 7, 2:34 pm, Chuck <chuckh1958_nos...@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?
>

Yes, since you have a QMNC process running. Since Datapump and
DBMS_SCHEDULER (along with possibly other options/utilities) use
Advanced Queueing behind the scenes I'm not surprised these slaves
exist.

.> The reason I'm asking is because yesterday one of our dba's dropped

a
> tablespace with a 30g datafile in it, them manually rm'ed the file from
> the OS (Solaris 10). The space never got released so we went looking for
> a process that might have had the file open. We found it was still

> opened by ora_q001.- Hide quoted text -
>
> - Show quoted text -

David Fitzjarrell

Tim X

unread,

Jan 8, 2009, 5:55:46 PM1/8/09

to

Chuck <chuckh19...@gmail.com> writes:

> ddf wrote:
>> On Jan 7, 2:34 pm, Chuck <chuckh1958_nos...@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