Embarcadero SQL Profiler is an optional add-on module that allows Oracle DBAs and Developers to quickly and easily identify poorly running code within their databases. A rich, “working” graphical interface provides the backdrop for users to pinpoint and tune the most expensive code in their applications. Once captured, profiling session data is stored so sessions can be historically compared to determine the effectiveness of incremental code tuning.

From within the familiar DBArtisan or Rapid SQL Pro console, Embarcadero SQL Profiler lets users start, stop, and analyze profiling sessions with simple point-and-click ease. To accommodate users who want to capture profiling sessions for long-running code objects, the graphical displays can be set to show in milliseconds, seconds, and even minutes.

Embarcadero SQL Profiler is available as a licensed add-on within DBArtisan and Rapid SQL Pro.

Embarcadero SQL Profiler is equipped with functionality that makes data capture easy, including:

• Start, which begins a new profiling session or opens a previous profiling session.
• Flush, which moves data from dynamic tables into analysis tables for reference.
• Run Summary, which enables you to view the date and total time for each profile.
• Run Detail, which enables you to view the code object’s owner, object type, and execution times for each code object captured by the profiling session.
• Clear Profile Table, which deletes data from your profile tables.
• Stop, which pauses the data gathering operation.
• Stop & Analyze, which populates the summary tables to view the Unit Detail and Run Summary windows.

With Embarcadero SQL Profiler, programmers can view the information for all runs of the object, or filter profile information based on the unit type or unit owner. Capabilities include:

• Unit Summary, which enables you to run time statistics for each code object captured in a profiling session.
• Unit Detail, which enables you to drill into a profiling session and view the length of time it took each line of source code to execute.

The Advanced View of Embarcadero SQL Profiler Unit Detail window contains the following information for each profile:

• Hit Lines
• Missed Lines
• Line Number
• Calls
• Percentage of the Total Time
• Average Time
• Minimum Time
• Maximum Time
• Total Time

Embarcadero SQL Profiler supports the following DBMS versions running on UNIX®, Linux, and Windows®-based servers:

• Oracle 8.0 and above

• Windows 98, NT, 2000, or XP
• 64MB memory
• 42 MB disk space