Show TOC

SAP Client (Oracle)Locate this document in the navigation structure

 SAP Client (Oracle)

Use

You can use this procedure to display the SAP client.

Procedure
  1. Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Activity

    Alternatively, use transaction code ST04.

  2. Choose Detail analysis menu →SAP Client.

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