Re: What is the ora_q000 process

From: ddf <oratune_at_msn.com>
Date: Thu, 8 Jan 2009 07:10:35 -0800 (PST)
Message-ID: <2b394cd1-1a52-4204-a866-a2a537db58cf_at_x38g2000yqj.googlegroups.com>

On Jan 7, 4:19 pm, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
> 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?
>

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 Received on Thu Jan 08 2009 - 09:10:35 CST