Ansicht
Dokumentation

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

------------------------------------------------------------------------

| 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  

------------------------------------------------------------------------