Quickly identify errors and potential bottlenecks in SQL

• Easy data capture
• Multiple profile views
• Detailed view for each profile

Embarcadero SQL Profiler, an optional module for DBArtisan and Rapid SQL, allows Oracle® DBAs and developers to quickly and easily identify performance bottlenecks within their databases. A rich, "working" graphical interface provides the backdrop for users to pinpoint and tune the most expensive code in their applications.

SQL Profiler offers:

• Elimination of bottlenecks
• Faster, better performing databases
• Higher programmer productivity

Identify and Isolate Performance Problems

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.

Profiling Data Capture

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.

Multiple Profile Views

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.

Advanced View Offers More Detail

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

DBMS Support

Embarcadero SQL Profiler supports the following DBMS versions running on both UNIX ® and Windows NT ®-based servers.

• Oracle 8i, 9i, 10g and 11g

System Requirements

• Windows® 2000, Windows 2003 (All editions), Windows 2003 R2 (All editions) and Windows XP (SP1 and SP2) and Windows Vista (Ultimate and Business) - 32-bit architecture only
• 512 MB memory
• 512 MB disk space
• DBMS Client connectivity utilities