Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10g R2 Streams Question

RE: 10g R2 Streams Question

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: 2006-01-06 21:58:00
Message-id: 20060106205800.34085.qmail@web50108.mail.yahoo.com


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                 



 Yahoo! DSL Something to write home about. Just $16.99/mo. or less Received on Fri Jan 06 2006 - 21:58:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US