ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

DisableMultiRowFetch connection parameter [DMRF]

Function 

To turn off multi-row fetches across the network

Usage 

Anywhere

Values 

YES, NO

Default 

NO

Description 

By default, when the database server gets a simple fetch request, the application asks for extra rows. You can disable this behavior by setting this parameter to ON.

For more information, see Using cursors in procedures and triggers.

Setting the DisableMultiRowFetch (DMRF) connection parameter to ON is equivalent to setting the PREFETCH database option to OFF. For more information, see Prefetching rows.

Example 

• The following connection string fragment prevents prefetching:

  DMRF=YES