A tool that reads and analyses event trace information from a database management system.

A profiling tool (profiler) reads event trace information that can be recorded by the database management system. These events can include queries being executed, particular query processing actions such as stored procedure executions or table scans or connection and session events. The profiling tool allows these to be examined and analysed.

Depending on the individual DBMS platform, various methods of recording trace information may be available - the DBMS can write out trace files, record the profiling information in a table or communicate with a client over interprocess communication or network links.

  • This link describes the process in the SQL Server profiler.

  • Tracing in Oracle is provided by the Oracle SQL Trace facility; the tkprof utility is used to examine trace files.

history | excerpt history