Ansicht
Dokumentation
dbs/ora/register_appl_info - Register application information in the Oracle Shared SQL Area
Addresses (Business Address Services) Addresses (Business Address Services)This documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter : dbs/ora/register_appl_info |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description : Register application information in the Oracle S |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
| This parameter is used to control if the current position of the |
| calling ABAP program should be reported to Oracle for a "prepare" |
| step in a SQL statement. Oracle stores this |
| information when storing the statement in the shared SQL |
| area. This allows you to use Transaction ST04 to go directly to the |
| calling area of the ABAP program from a SQL statement listed in the |
| display of the shared SQL area. |
| |
| The application information is reported to Oracle by calling a |
| standard Oracle procedure and therefore only slightly reduces |
| performance. This overhead (around 5 ms) is only needed when |
| "preparing" (parsing) an SQL statement. |
This effect should not be visible in a balanced system,
as the use of the R/3 statement cache should
prevent the use of "prepare" steps as much as possible.
------------------------------------------------------------------------
------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------
------------------------------------------------------------------------
Unit: 0 = deactivated (no application info is sent to
Oracle)
1 = activated (application info is sent to
Oracle)
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: 1 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Who is permitted to make changes: The customer |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: None |
------------------------------------------------------------------------
------------------------------------------------------------------------
Restrictions on database systems: Oracle
------------------------------------------------------------------------
------------------------------------------------------------------------
Are other parameters affected or dependent: No.
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid entries, formats, areas : 0 or 1 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : Register application information in the Oracle Shared SQL Area
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : B
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------
Addresses (Business Address Services) PERFORM Short Reference
This documentation is copyright by SAP AG.
Length: 5224 Date: 20240427 Time: 024929 sap01-206 ( 6 ms )
