Ansicht
Dokumentation

dbs/ora/array_buf_size - Size of input/output buffer used for array operations

dbs/ora/array_buf_size - Size of input/output buffer used for array operations

Addresses (Business Address Services)   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| 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
------------------------------------------------------------------------


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 5293 Date: 20240616 Time: 200033     sap01-206 ( 5 ms )