daniellima
New Member
I am using oracle database [11.2] with advanced queuing (AQ) w/ java JMS API. My current oracle setup is default settings, with no additional tuning parameters.High level architecture:Database enqueue message into persistent queue (sorted by priority)\[code\]EXEC DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'order_queue_table', queue_payload_type => 'aqadm.order_message_t', sort_list=>'PRIORITY,ENQ_TIME'); EXEC DBMS_AQADM.CREATE_QUEUE (queue_name => 'order_queue', queue_table => 'order_queue_table'); EXEC DBMS_AQADM.START_QUEUE (queue_name => 'order_queue');\[/code\]Java JMS consumer is dequeue messages with 3 concurrent threads. Everything is works great! and happy scenario, as long as messages in the queue @10K. As soon as messages in queue doubles or triples dequeue performance goes significantly down!!!. I followed following linkhttp://docs.oracle.com/cd/B28359_01/server.111/b28420/perform.htmAny suggestions on performance tuning on IO and AQ?