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
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Cross-ref: http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=82743
Previous Topic: ORA-03137
Next Topic: count(*) anomaly
Goto Forum:
  


Current Time: Thu Mar 28 09:20:54 CDT 2024