Debug Options
Go Up to Configuring Feature Options
The Debug tab of the Options Editor lets you specify operational preferences for the Debugger.
- Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
- Note: For information on using the Debugger, see IDERA SQL Debugger.
The table below describes the options and functionality on the Debug tab:
Tab | Option | Description | Default |
---|---|---|---|
General |
Dependency Tree Option |
Lets you specify pre-fetch levels. |
Pre-Fetch All Dependencies |
Profiler |
Profiler Time Unit |
Lets you select a unit of milliseconds, seconds or minutes. |
Milliseconds |
Save Profiler Reports |
Lets you save profiler reports and type or browse for the report path. |
Not Selected | |
Oracle |
Initialization Timeout (seconds) |
Specifies the point at which the application stops trying to initialize the debugger. If it cannot initialize the debugger in the specified time, it displays message in the Debug Output window. |
60 |
Debug Session Timeout (seconds) |
Specifies the point at which the application terminates your debug session due to idle time. |
7200 | |
Enable DBMS Output |
Enables the Oracle built-in package, DBMS_OUTPUT, letting you send messages from stored procedures, packages, and triggers. |
Selected | |
Refresh Dependencies for each run |
Refreshes the dependencies each time you run the debugger. |
Not selected | |
Compile with Debug Option |
When debugging a procedure against an Oracle datasource, a compilation is performed before debugging. During a compilation, Oracle invalidates referencing objects. For example, if procedures A2 and A3 both reference procedure A1, debugging procedure A1 will result in procedures A2 and A3 being marked as invalidated. The Compile with Debug Options settings let you control compilation of dependent objects while debugging. |
Compile dependent options | |
DB2 |
Debug Session Timeout (seconds) |
Specifies the point at which the application terminates your debug session due to idle time. |
300 |
Compile with Debug Option before Debug Session |
Lets you specify options. |
Prompt Always |