Database Reference
In-Depth Information
• Connecting to presentation layer (SAP GUI)
• Distributing load evenly across all the configured work processes
Work Process Connection to the Database
The SAP work process runs at the operating system level with <SID>adm user account cre-
ated at the time of the system installation. However, the underlying Oracle Database is
owned by a user called SAP<SCHEMA-ID>. SAP work processes, therefore, while estab-
lishing a connection to the underlying Oracle Database retrieve the password for user
SAP<SCHEMA-ID> from a SAP table called SAPUSER. After the SAP work process re-
trieves the password, it will go on to connect to the underlying Oracle Database. Once the
work process establishes a connection to the database, it keeps it for the entire runtime of
the SAP system. The connections are terminated only when the SAP system is shut down.
The following shows the connection details of the SAP work process to the underlying
Oracle Database for SAP<SCHEMA-ID> = SAPBDX and SAP SID = BD1:
