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

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

More Oracle Errors Interview Questions

ORA-13251: duplicate entry string in metadata table

1 Answers  


ORA-31055: A null XMLType element cannot be inserted into RESOURCE_VIEW

1 Answers  


TNS-00240: Connection Manager: Logging is now ON

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


NNL-00997: NO SUCH NAME responses received: number

1 Answers  






RMAN-06192: maximum value for MAXPIECESIZE or MAXSETSIZE must be between 1 Kb and 2048 Gb

1 Answers  


ORA-16799: Physical apply service is offline

1 Answers  


ORA-01983: invalid auditing option for DEFAULT

1 Answers  


QSM-02127: not supported for this type mv by Oracle version at master site

1 Answers  


ORA-13048: recursive SQL fetch error

1 Answers  


ORA-38430: Operation "string" not supported in the current release.

1 Answers  


ORA-06730: TLI Driver: unable to open clone device

1 Answers  


Categories