SAP Client (Oracle)
You can use this procedure to display the SAP client.
Alternatively, use transaction code ST04.
You can analyze the workload of the database for each application server in the SAP system. This helps you find out which application servers put the highest workload on the database.
The fields on the statistics screen contain the following information:
Information on the Statistics Screen
Field | Information |
---|---|
Current Open Cursors |
Number of open cursors or context areas occupied on the application server by user processes |
User calls |
Number of database queries from users |
Recursive calls |
Number of internal data dictionary queries |
User commits |
Number of user transactions performed |
User rollbacks |
Number of user transactions terminated |
Parse count |
Number of "parsed" SQL statements |
Database block gets |
Number of logical read operations required to call the current version of the required data |
Consistent gets |
Number of logical read operations required to call a consistent version of the required data |
Physical reads/writes |
Number of physical read and write operations performed in the database |
Redo blocks written |
Number of blocks written by the log writer in the redo log |
Long table scans, rows gotten |
Number of full table scans of tables larger than four blocks and number of data records read sequentially |
Table fetch by row ID |
Number of table data records accessed directly |
Table fetch by continued row |
Number of chained data records that were read |