Performing request trace analysis

When you have a specific application or request that is problematic, you can perform a request trace analysis to determine
the problem. Request trace analysis configures the Database Tracing Wizard to narrow diagnostic data gathering to only the user, connection, or request that is experiencing the problem.

Prerequisites

DBA or PROFILE authority.

Context and remarks

Using the various data viewing tools in Application Profiling mode, you can identify any potential conflicts or bottlenecks.

You can select from several tabs that provide you with different views of the data gathered for your analysis. For example,
the Summary tab allows you to see all requests executed against the database during the tracing session, including how many times each
request was executed, execution duration times, the user who executed the request, and so on. If the list is long and you
are looking for a specific request, click the Filtering title bar on the Summary tab and enter a string in the SQL Statements Containing field.

Next

To view more details about a specific request, right-click the request and click Show The Detailed SQL Statements For The Selected Summary Statement. The Details tab opens. Right-click the row containing the request, and additional choices for information are provided, including viewing
additional SQL statement, connection, and blocking details.