Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    Problems with SIP2 connections

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    Sometimes during late evening we are having connection problems and timeouts on our self check machines. Is there any problem with Alephs SIP2 server?
    Last occurrence of this problem was Wed Nov 09 around 22:00.

    Cause:
    SYS_AUTO_SQL_TUNING_TASK is running

    Resolution:
    In Oracle alert log we see that at this time scheduled tuning job SYS_AUTO_SQL_TUNING_TASK was running:

    Wed Nov 09 22:00:04 2011
    Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
    Wed Nov 09 22:00:48 2011
    Thread 1 advanced to log sequence 59967 (LGWR switch)
    Current log# 5 seq# 59967 mem# 0: /oracle/oradata/aleph0/aleph0_redo_05.log
    Wed Nov 09 22:17:13 2011
    End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK

    This job is used to tune SQL queries and very heavy for Oracle DB. So in case you have problems with SIP2 connections we recommend to reschedule it to a time where SIP2 server (and other Aleph processes) are down so that there is no conflict. In general it is sufficient to perform the job once a week.

    In attached document you find instructions how to reschedule the job using Oracle OEM console.

    Category: Circulation (500)

    Subject: Self check (500)

    • Article last edited: 10/8/2013