Home » RDBMS Server » Performance Tuning » performance issue with oracle AQ while dequeueing the table (11.2.0.3 , 3 node-RAC, solaris 11)
performance issue with oracle AQ while dequeueing the table [message #651387] Tue, 17 May 2016 02:33 Go to next message
pavanintouch
Messages: 6
Registered: March 2014
Location: hyderabad
Junior Member
Hi,

recently we got a performance issue with our 3 -node rac . multiple locking are forming on our AQ tables.
when we saw awr we found delayed executions on begin dbms_aqin.aq$_dequeue_in..... .
Point is dequeue process is very slow compared to insert in queue table.

can any one advise how to tune it/make it faster?

Thanks
Pavan

Report message to a moderator

Re: performance issue with oracle AQ while dequeueing the table [message #651390 is a reply to message #651387] Tue, 17 May 2016 03:20 Go to previous message
Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Cross-ref: http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=82743

Report message to a moderator

Previous Topic: ORA-03137
Next Topic: count(*) anomaly
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 15 03:44:22 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.