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!
  
  - Kirti 
  

Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote:  What's the value for 
parallel_max_servers?  Try to increase it.

Igor 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Carlson, Todd
Sent: Friday, January 06, 2006 2:03 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx]
Sent: Friday, January 06, 2006 12:37 PM
To: Carlson, Todd; oracle-l@xxxxxxxxxxxxx
Subject: RE: 10g R2 Streams Question

How many capture processes are you running on source db? 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Carlson, Todd
Sent: Friday, January 06, 2006 1:30 PM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: