A script-enabled browser is required for this page to function properly.

DML Array Size Property

Description

Specifies the maximum array size for inserting, updating, and deleting records in the database at one time.

Applies to block

Set Oracle Forms

Default

1

Usage Notes

A larger size reduces transaction processing time by reducing network traffic to the database, but requires more memory. The optimal size is the number of records a user modifies in one transaction.

DML Array Size Restrictions

Minimium number of records is 1; there is no maximum.