Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10g R2 Streams Question
It will also be beneficial to find out if there are any objects in the database with \
parallel degrees set higher, or queries with parallel hints. And if these have kept \
parallel servers busy when starting Capture process you are likely to run into this \
error. A quick look at V$PQ_SYSSTAT will help you set the parallel_min and parallel_max \
servers values judiciously.
Cheers!
Igor Neyman wrote: What's the value for parallel_max_servers? Try to increase it.
Igor
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carlson, Todd
Sent: Friday, January 06, 2006 2:03 PM
To: oracle-l_at_freelists.org
Subject: RE: 10g R2 Streams Question
Hey Igor,
That is the confusing part. I have just one capture process. It seems that it should have everything it needs...
Thanks,
Todd
-----Original Message-----
From: Igor Neyman [mailto:ineyman_at_perceptron.com]
Sent: Friday, January 06, 2006 12:37 PM
To: Carlson, Todd; oracle-l_at_freelists.org
Subject: RE: 10g R2 Streams Question
How many capture processes are you running on source db?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carlson, Todd
Sent: Friday, January 06, 2006 1:30 PM
To: oracle-l_at_freelists.org
Subject: 10g R2 Streams Question
Hey Guys,
I am working with streams on RHEL4 & EE 10g R2. I have read the docs and setup a capture DB and a apply DB. I built my scripts using the example from Note:224255. However, the capture job will not enable and I get this error message in the alert log: ORA-01372: Insufficient processes for specified LogMiner operation. The dump files basically state the same thing.
The parameters are set to the doc specs. I have processes=150, job_queue_process=10, aq_tm_processes=4, logmnr_max_persistent_sessions=3. Has anyone seen this error message? If so, what did you do to fix it?
Thanks,
Todd
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l