SAP Application Dataflow in the Oracle Database

In SAP applications, end-user requests are processed by the Oracle database as follows:

1. The end user logs into the SAP system via the SAP front end and executes a business transaction.

2. The user request is executed by the SAP dialog work process.

3. The Oracle server detects the incoming call, accepts the call, and sets up a dedicated server process.

4. There is a one-to-one relationship between SAP work processes and Oracle server (shadow) processes.

5. The user runs the SQL statement and commits the transaction.

6. The server process looks into the shared pool of the Oracle Database for any reusable SQL.

7. If it finds a reusable SQL, then it verifies authorization.

8. If it does not find ...

Get SAP Basis Administration Handbook, NetWeaver Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.