RE: 10g R2 Streams Question
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 6 Jan 2006 12:58:00 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Yahoo! DSL Something to write home about. Just $16.99/mo. or less
Other related posts:
