Other Filters 

You can also filter the trace record display using the following parameters:

·        User

·        Objects

–         SQL trace: Table name that the SQL statement refers to

–         Enqueue trace: Lock object that the statement refers to

–         RFC trace: Instance on which a function is executed

–         Table buffer trace: Name of the table that the access is limited too

·        Duration

·        Operations

–         SQL trace: Database operations

–         Enqueue trace: Operation for the lock object

–         RFC trace: Characteristics of the execution (client/server)

–         Table buffer trace: Name of the buffer operation

 

The default filters are:

-          For User, the current user

-          For Objects, the display of the system tables is suppressed. Currently, these are the tables D010*, REPOLOAD, REPOSRC, REPOTEXT, DYNPSOURCE, DYNPLOAD, DYNPTXTLD, DDLOG.

The Duration and Operations parameters are not initialized

You can specify a numeric value for the Duration. This is measured in microseconds. For all other parameters, you can enter a pattern or name. In addition to alphanumeric characters, you can also use the wildcard characters ‘*’ and '+’ in patterns.

You can also change the operator in a specification for further filtering. To do this, position the cursor on the relevant parameter and choose Selection Options. A dialog box then appears in which you can specify whether trace records satisfying the condition should be included (green traffic light) or excluded (red traffic light) from the selection.

For the duration, restricting to an interval of 1000 to 5000 seconds may be of use.