GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Advance Queue performance improvement in 12.1.0.2

edited Jun 13, 2015 10:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

I am not expert in AQ and need advice here as one of the customer need the following information.

1.Are the following parameters are sufficient  to increase the speed of the queues ? or any other way to speed up queue

_srvntfn_job_deq_timeout=180

_srvntfn_q_msgcount_inc=1

_srvntfn_q_msgcount=250

_srvntfn_jobsubmit_interval=1

_srvntfn_max_concurrent_jobs=100

2.We  register  a procedure dbms_aq.register to process a queue and we realized that there are a maximum of two processes

  perform the procedure registered.

   Is it possible to increase the number of process that perform the procedure ?

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