Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    clear_vir01 takes much longer in version 20

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We run clear_vir01 Monday through Friday in the hot mode. We run it in the cold mode on Saturday morning.

    When we were on version 19 in Oracle 10, the hot-mode job took at most a couple of minutes. Now that we are on version 20 and Oracle 11 the job takes hours. Today it took 5 hours.

    We were running it on Sunday mornings in hot mode, but quit because we sometimes do system maintenance then and it was taking hours to clean up just 10's of thousands of records. During the week we regularly have 100,000 Z05 records and 10's of thousands of Z64 records daily. This means we have to clean up the VIR01. We have exceeded the 1,000,000 limit on Z05 records in the past during a one week period.

    Resolution:
    Corrected by:

    v20 - rep_change 3463
    v21 - rep_ver 17373


    • Article last edited: 10/8/2013
    //doorbell.io feedback widged