Syntax options:

    DETECTED ASYNC PREFETCH IS ENABLED | DETECTED ASYNC PREFETCH IS
    DISABLED

    Specifies whether or not Oracle Rdb reduces the amount of time
    that a process waits for pages to be read from disk.

    By using heuristics, detected asynchronous prefetch determines if
    an I/O pattern is sequential in behavior even if sequential I/O
    is not actually executing at the time. For example, when a LIST
    OF BYTE VARYING column is fetched, the heuristics detect that
    the pages being fetched are sequential and asynchronously fetches
    pages further in the sequence. This avoids wait times when the
    page is really needed.

    Detected asynchronous prefetch is enabled by default.