Ansicht
Dokumentation
dbs/ora/close_stmt_after_exec - Close SQL statement after execution
Addresses (Business Address Services) BAL Application Log DocumentationThis documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter : dbs/ora/close_stmt_after_exec |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Close SQL statement after execution |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
| This parameter lets you force SQL statements to close immediately |
| after execution for Oracle and release all the resources |
| allocated in this context. |
| |
| For performance reasons, this normally does not happen. A |
| Statement-Cache is implemented in the DB interface in which |
| a certain number of SQL statements for the database are held open. |
| The advantage of this cache is that when the same SQL statements |
| are called more than once, it saves certain DB calls, and thus |
| "server roundtrips" |
| |
| Certain Oracle functions, such as that for closing a database |
| link, can only be executed successfully when all SQL statements are |
| closed for the database. In such an instance, you can force the |
| system to close immediately after the statement is executed by |
| setting this parameter. |
| parameter. |
| |
| The following parameters are allowed: |
| |
| 0 ==> Statements are re-used (default) |
| 1 ==> All Native SQL statements are closed immediately after they |
| are executed. |
| 2 ==> All open and native SQL statements are closed immediately |
| after they are executed. |
| |
| Normally this parameter should be left with its default value for |
| performance reasons. In some cases it may be useful to set this |
| parameter to 1 when you use database lins via the native SQL |
| interface in order to close database links again after they are |
| used. The parameter value 2 only should be used as a workaround |
| when certain errors occur. |
------------------------------------------------------------------------
------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit : |
------------------------------------------------------------------------
------------------------------------------------------------------------
Default value : 0
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: None |
------------------------------------------------------------------------
------------------------------------------------------------------------
Restrictions on database systems: Oracle
------------------------------------------------------------------------
------------------------------------------------------------------------
| Other parameters affected or dependent: None |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid entries, formats, ranges : { 0, 1, 2 } |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : Close SQL statement after execution
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Minimum : 0
------------------------------------------------------------------------
------------------------------------------------------------------------
| Maximum : 2
------------------------------------------------------------------------
ROGBILLS - Synchronize billing plans Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 6821 Date: 20240425 Time: 193102 sap01-206 ( 6 ms )
