Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  PAGE_TRANSFER
    Syntax options:

    PAGE TRANSFER VIA DISK | PAGE TRANSFER VIA MEMORY

    Specifies whether Oracle Rdb transfers (flushes) pages to disk or
    to memory.

    When you specify PAGE TRANSFER VIA MEMORY, processes on a single
    node can share and update database pages in memory without
    transferring the pages to disk. It is not necessary for a process
    to write a modified page to disk before another process accesses
    the page.

    The default is to DISK. If you specify PAGE TRANSFER VIA MEMORY,
    the database must have the following characteristics:

    o  The NUMBER OF NODES must be one, or SINGLE INSTANCE must be
       specified in the NUMBER OF CLUSTER NODES clause.

    o  GLOBAL BUFFERS must be enabled.

    o  After-image journaling must be enabled.

    o  FAST COMMIT must be enabled.

    If the database does not have these characteristics, Oracle Rdb
    will perform page transfers via disk.

    For more information about page transfers, see the Oracle Rdb7
    Guide to Database Performance and Tuning.
Close Help