Using Application Tracing ToolsPosted: 20/11/2010
Oracle provides several tracing tools that can help you monitor and analyze applications running against an Oracle database.
End to End Application Tracing can identify the source of an excessive workload, such as a high load SQL statement, by client identifier, service, module, action, session, instance, or an entire database. This isolates the problem to a specific user, service, session, or application component.
Oracle provides the
trcsess command-line utility that consolidates tracing information based on specific criteria.
The SQL Trace facility and
TKPROF are two basic performance diagnostic tools that can help you monitor applications running against the Oracle Server.
This chapter contains the following sections:
- End to End Application Tracing
- Using the trcsess Utility
- Understanding SQL Trace and TKPROF
- Using the SQL Trace Facility and TKPROF
- Avoiding Pitfalls in TKPROF Interpretation
- Sample TKPROF Output