Array interface

The LN Oracle database driver can use multirow features of the OCI interface for array fetches and array inserts. With the array interface, communication between the Oracle driver and the Oracle server is more efficient, multiple rows are fetched or inserted with a single OCI call. Because multiple rows are stored in a buffer in the LN Oracle database driver, more memory is consumed. Array interfacing is useful if you access a remote database, because the number of network round-trips is reduced.

The default number of rows fetched with a single OCI call is 5. To change this setting, you can specify the resource ora_max_array_fetch. To disable the array interface, set ora_max_array_fetch:1.

The default number of records buffered during insert and passed to Oracle with a single OCI call is 1; to change this value, you can specify the resource ora_max_array_insert.

During data loading using the bdbpost or bdbreconfig utility, the number of buffered records is specified by the table_load_array_size resource.