dbs/ora/array_buf_size - Size of input/output buffer used for array operations
Vendor Master (General Section) Addresses (Business Address Services)This documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter : dbs/ora/array_buf_size |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Size of input/output buffer used for array oper. |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
This parameter defines the size of a data area, with which the
input and output values of an SQL statement are transferred to the
Oracle database. It influences in particular
the maximum number of records that are brought into the
database with an array operation (e.g. array insert) or are read
from there (array fetch). The larger the selected value, the more
records can be transferred from or to the database with a single
database operation. However the Oracle network software also
partitions the data to be transported again, so that increasing the
value may not necessarily lead to a reduction in network
traffic.
| |
The default value of the parameter is -1. This means that an
internal system default value is used for the size of the array
buffer. This default value should only be changed in consultation
with SAP.
------------------------------------------------------------------------
------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit: Bytes |
------------------------------------------------------------------------
------------------------------------------------------------------------
Default value: -1
------------------------------------------------------------------------
------------------------------------------------------------------------
Who is permitted to make changes: SAP
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: None |
------------------------------------------------------------------------
------------------------------------------------------------------------
Restrictions on database systems: Oracle
------------------------------------------------------------------------
------------------------------------------------------------------------
Are other parameters affected or dependent: No
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : Size of input/output buffer used for array operations
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Minimum : 0
------------------------------------------------------------------------
------------------------------------------------------------------------
| Maximum : 1000000
------------------------------------------------------------------------
General Material Data BAL Application Log Documentation
This documentation is copyright by SAP AG.
Length: 5115 Date: 20120525 Time: 164220 triton ( 22 ms )
