The following table describes the corresponding measure types:
| Measure | Description |
|---|---|
| Parse | The time, in seconds, that it takes to prepare (Oracle terminology: parse) a SQL command. Preparing a SQL command usually
includes a server round-trip during which the SQL command is sent to the server. The SQL command is then parsed and transformed
into an internal format that can be reused on subsequent calls of that SQL command.
Note: If you use the
OraParse function with the
ORA_DEFERRED option, the parsing of the SQL command is deferred to the execute step, and the server round-trip time is produced for the
parse step. In this case, this measure type is meaningless.
|
| Exec | The time, in seconds, in which a SQL command is executed. Executing a SQL command includes at least one server round-trip for sending the command and returning the result to enable the SQL command to be executed. Because of the considerable amount of data processing required on the server for a SQL command, executing SQL commands usually generates a major part of the load on the database server. A separate measure type in the SQL measure group is used for fetching data. Fetching data can either be included as part of the execute step or in a separate step. In the latter case, results are not included in the SQL measure group. |
| ExecDirect | The time, in seconds, in which a SQL command is prepared and executed. |