Parameter
dbs/ora/register_appl_info
Short text
Register application information in the Oracle S
Parameter Description
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.
Application Area
Database
Parameter 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?
Customer
Operating System Restrictions
None
Database System Restrictions
Oracle
Are other parameters affected or dependent?
No.
Values allowed
0 or 1
