ORA-25307: Enqueue rate too high. Enable flow control

Question Posted / guest

3 Answers
13634 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-25307: Enqueue rate too high. Enable flow control..

Answer / michael ojejinmi

to resolve this what i did was to stop and restart the
capture and apply processes on the source and destination
databases, and this resolved the problem.

Is This Answer Correct ?

2 Yes

0 No

ORA-25307: Enqueue rate too high. Enable flow control..

Answer / michael ojejinmi

Also if you don't dedicate a large enough streams pool size
to your source database, then the streams process uses your
shared pool(about 10% of it), if thats already pegged by
not using binds, then there'll not be enough shared memory
for your source database queue, thereby resulting in a
queue buffer overflow, so increase your streams_pool_size
parameter, that should help with the ORA_25307 error.

Is This Answer Correct ?

0 Yes

1 No

ORA-25307: Enqueue rate too high. Enable flow control..

Answer / guest

Cause: Subscribers cannot keep pace with the enqueue rate.

Action: Try enqueue after sleeping for some time.

Please add more information about this Error

Is This Answer Correct ?

1 Yes

3 No

Post New Answer