Sharded Queue problem

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.

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.

Hi Sean -

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

-John

1 Like