When an AQ sharded queue is created, there is nothing that notes that in the schema browser and the script generation uses the wrong procedure to recreate them. There doesn't appear to be an option to create one via the gui either.

Hi Sean, I added some sharding support to Toad 3 or 4 years ago. I don't recall doing anything special with Queues (or even seeing anything in the docs about it). But it was a while ago - maybe something was added to latest version (or maybe I just missed it!) Can you give me an example of the command you're using to create a sharded queue? Thanks -John

BEGIN DBMS_AQADM.create_sharded_queue( queue_name => 'MY_SHARDED_QUEUE', max_retries => 5, multiple_consumers => FALSE, queue_payload_type => DBMS_AQADM.jms_type ); END;

Yeah, I definitely don't have support for that in Toad. I'll log it and try to get to it soon. Please let me know if you notice anything else that's not supported, shard-wise. Thanks

Hey Sean, I am trying to set this up on a system-managed sharded db (19c) and am running into this. Oracle is giving me an error for a non-allshard user, but I am an all-shard user. Did you run into this? Which Oracle version are you using? I don't see anything helpful online about this. [image]

The database doesn't need to be sharded. Within AQ, "sharding" has its own meaning unrelated to database sharding. The database I was using is not sharded.

Oh! Well, that makes things a lot simpler! Thanks.

Sharded Queue problem

Toad for Oracle & DevOps Toolkit

JohnDorlon February 13, 2023, 8:47pm 8

Hi Sean -

We added support for Sharded Queues in today's beta, which you can get here.

-John

Topic		Replies	Views
Advanced queue table script Toad for Oracle & DevOps Toolkit	2	5121	April 2, 2014
Bug in Toad for Oracle25.3.346.7343 Toad for Oracle & DevOps Toolkit	2	77	August 6, 2026
Unable to View Queue Statistics Toad for Oracle & DevOps Toolkit	3	821	April 3, 2023
QUEUE_TO_QUEUE parameter not generated Toad for Oracle & DevOps Toolkit	4	812	May 19, 2022
SQL Queries are getting queued for few users in Toad Toad for Oracle & DevOps Toolkit	1	991	January 11, 2015

Sharded Queue problem

Related topics