SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  LOG_SERVER
    Syntax options:

    LOG SERVER IS MANUAL | LOG SERVER IS AUTOMATIC

    Specifies if the AIJ log server (ALS) is activated manually or
    automatically. The default is manual.

    Multiple-user databases with medium to high update activity
    can experience after-image journal (.aij) file bottlenecks.
    To alleviate these bottlenecks, you can specify the LOG SERVER
    clause to transfer log data to the .aij file either automatically
    or manually. On a single node with ALS, there is no AIJ locking.

    If the log server is set to MANUAL, you must execute the RMU
    Server After_Journal command with the Start qualifier to start
    the log server. In this case, the database must already be open.
    If the OPEN IS MANUAL clause was specified, an explicit RMU Open
    command needs to be executed before the log server is started.
    If the OPEN IS AUTOMATIC clause was specified, at least one
    user should be attached to the database before the log server
    is started.

    If the log server is set to AUTOMATIC, the log server starts when
    the database is opened, automatically or manually, and is shut
    down when the database is closed.

    For more information on setting log servers, see the Oracle Rdb7
    Guide to Database Performance and Tuning.
Close Help