GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

auto stats collection job occupies the job queue processes and none is available for streams propaga

edited Jun 1, 2010 5:20AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Hi,

      We have streams setup in production for replicating only few tables. It is unidirectional.

job queue process is set to 2 in the source database.

In the night at 22:00 JST, the automatic stats gather job is occupying both these job queue processes and propagation is not happening or getting delayed till the stats gather job completes.

   Even if I increase the job queue processes, I suspect automatic stats gather job might use all the available job queue processes.

Is there any maximum limit for auto stats job to use the job queue processes?

Is there any way to restrict the no. of job queue processes used by auto stats job?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center