dbs/ora/register_appl_info SAP Parameter attribute - Register application information in the Oracle Shared SQL Area

dbs/ora/register_appl_info is a SAP Parameter attribute which is used to control Register application information in the Oracle Shared SQL Area information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

dbs/ora/register_appl_info profile paramerter attributes

Parameter Name: dbs/ora/register_appl_info
Description: Register application information in the Oracle Shared SQL Area
Default Value: 1
Parameter Type ( See IF_PARAMETER_TYPES): Boolean(BOOL)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-ORA
System-Wide parameter: No
Dynamic Parameter: No
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

This parameter is used to control whether the current position in the calling ABAP program should be reported to Oracle for a "prepare" step in an SQL statement. Oracle then stores this information when storing the statement in the shared SQL area. This allows you to use transaction ST04 to go directly to the call point in the ABAP program from a displayed SQL statement when displaying the shared SQL area. The application information is reported to Oracle by calling a standard Oracle procedure and therefore only slightly reduces performance. However, this overhead (around 5 ms) is only needed when "preparing" (parsing) an SQL statement. This effect should not be visible in a tuned system because the use of the R/3 statement cache should prevent the use of "prepare" steps as much as possible.

See SAP Parameter Documentation for full SAP documentation for this profile parameter.