Use DBMS_MONITOR to track database operations, SQL Test Case Builder to package information relating to a performance problem, and SQL Trace to generate diagnostic data for problem SQL statements.

This part contains the following chapters:

• Monitoring Database Operations
  This chapter describes how to monitor SQL and PL/SQL.
• Gathering Diagnostic Data with SQL Test Case Builder
  SQL Test Case Builder is a tool that automatically gathers information needed to reproduce the problem in a different database instance.
• Performing Application Tracing
  This chapter explains what end-to-end application tracing is, and how to generate and read trace files.