The performance of the FETCH statement is improved if the cursor associated with the statement is opened as a read-only cursor.

For read-only cursors, the DBMS Server prefetches rows to improve performance. To disable prefetching or specify the number of rows that are prefetched, use the SET_SQL(PREFETCHROWS) statement.