OraFAQ Forum: Streams & AQ » Sql Statement for to see if the job is in Queue or not?

Home » Server Options » Streams & AQ » Sql Statement for to see if the job is in Queue or not? (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql Statement for to see if the job is in Queue or not? [message #633531]

Fri, 20 February 2015 14:38

gentleman777us
Messages: 122
Registered: April 2005

Senior Member

Hi,

Iam new to AQ's. Iam modifying existing queues to single consumer. What is the sql statment to check for the queues to make sure that my modification are working fine.

Thanks

Report message to a moderator

Re: Sql Statement for to see if the job is in Queue or not? [message #633532 is a reply to message #633531]

Fri, 20 February 2015 15:24

Michel Cadot
Messages: 68447
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe checking DBA/ALL/USER_QUEUES% views.

I'm really surprised that someone who has been working with Oracle database for 10 years is not able to query DICT view or read Database Reference book.

[Updated on: Fri, 20 February 2015 15:26]

Report message to a moderator

Re: Sql Statement for to see if the job is in Queue or not? [message #633534 is a reply to message #633532]

Fri, 20 February 2015 15:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Iam modifying existing queues to single consumer.

using COPY & PASTE show us how you know which to modify & show us how exactly you modified them.

Report message to a moderator

Re: Sql Statement for to see if the job is in Queue or not? [message #633537 is a reply to message #633534]

Fri, 20 February 2015 15:53

gentleman777us
Messages: 122
Registered: April 2005

Senior Member

I know these tables very well, However I could not find some of the jobs in those tables. I was wondering if there are other tables I should be looking.

Report message to a moderator

Re: Sql Statement for to see if the job is in Queue or not? [message #633546 is a reply to message #633537]

Sat, 21 February 2015 00:51

Michel Cadot
Messages: 68447
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As we don't know which tables you know and which "jobs" you see and which ones you don't see, we can't help.

[Updated on: Sat, 21 February 2015 01:08]

Report message to a moderator

Previous Topic:	messages not consuming from MQ to AQ
Next Topic:	MGW and MQ Message Duplication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 30 01:46:56 CDT 2023