dcsimg
Results 1 to 3 of 3

Thread: GG extract process running slow and lag is in increasing mode. GG 12.1.0.2 oracle12c

Hybrid View

  1. #1
    Join Date
    Oct 2015
    Posts
    2

    GG extract process running slow and lag is in increasing mode. GG 12.1.0.2 oracle12c

    Hi,

    I am running in the situation where lag on extract process is in increasing mode.

    Observation : Lag in integrated extract process is in increasing mode.

    I tried restarting the extract process but even after restarting lag is in increasing mode.

    Then I have restarted the oracle database and after that lag got cleared.

    Question :
    1. What are the possible reason for increasing in extract lag.
    2. What things I should check at that time.
    3. I can see that after restarting the DB lag got removed, Seems some contention in database and after restart of DB lag got removed, what are the possible contention for the same.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,913
    Are you talking about data guard standby lagging behind primary?

    How is data guard configured, is it archived log based or redo log based?.

  3. #3
    Join Date
    Oct 2015
    Posts
    2

    No I am talking about oracle goldengate lag in extract process.

    No I am talking about oracle goldengate lag in extract process.

    Quote Originally Posted by skhanal View Post
    Are you talking about data guard standby lagging behind primary?

    How is data guard configured, is it archived log based or redo log based?.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •