Execute Consolte allow execute stored programs, including procedures, packages, package bodies, and functions with options for selecting the entry point, previewing the PL/SQL code block, setting IN parameters, displaying OUT parameters, and viewing results. Store Program can executed from Database Explorer or PL/SQL Editor.
The Explain Plan interface, a statement analysis tool, is used to describe and optimize the access paths of your SQL code using both the standard tree and a step-by-step description of each execution.
The Integrated PL/SQL Debugger allows a user to diagnose complications within
Profiler interface grants the ability to execute and cache statistical information on PL/SQL blocks and methods (packages, procedures, etc.). The Profiler Analysis displays this statistical information allowing a user to compare executions or view the execution statistics line by line to determine performance problems.
Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
The SQL formatter provides a quick and easy way of formatting SQL statements. The fomatter has different options to allow users the ability to customize the formatter to his preference.