High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Gathering table statistics on primary impacting apply on logical standby

We have been hit with a issue where manually gathering stats on the primary database is slowing down the apply on the logical standby by a lag of almost 6 hours to catchup.

Due to some performance issue on our primary database we had been advised by our third party vendor to disable the scheduled nightly default gather stats job and manually gather stats on the application schema tables via their script which we are running via cron.

Ever since we are running the gather stats manually the logical standby lags behind and taken almost 6 hours to catchup after the gather stats job completes on primary.

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