GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Queue table locking

edited Feb 17, 2010 10:11PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
 Hello,

We are facing the following problem in our AQ messaging infrastructure (production):

Trying to start an exception queue (via dbms_aqadm.start_queue), hangs on table exclusive lock taken by application sessions. As many sessions continuously post and collect messages in parallel, start_queue never happens!

The table locks are taken by dbms_AQIN, within OJMS transactions. RDBMS is 10.2.0.3 on HP-UX.

Seems a severe performance issue that Enque/Dequeue transactions do more than row locking on queue tables !?

Any help appreciated.

Regards,

Robert.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center