Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Can we prevent Held Log situation.

    Hi Guys,

    On one of our production DBs, sometimes I see LOG Held situation. For this I have written Held Log Monitor which has worked last night and forced one bad application off.

    This situation is not so frequent, still happens once a while. For this, the monitor runs every 15 minutes to see if logs are being used excessively and then it queries DB snapshot to find the holding agent_id to force it off.

    This has resolved the problematic situation successfully. Now I have further question to know if we can avoid or prevent the situation absolutely ??


    The monitor runs 12x4 = 48 times a day.

    Can we prevent the situation with permanant solution so that we do not have to use the monitor to force of anything ??


    Regards

    DBFinder

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You could use max_log / num_log_span db cfg parameters

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    You would be better off ensuring that your applications issue periodic commits in their processing.
    Dave

Posting Permissions

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