Chat now with support
Chat with Support

Toad Edge 1.1 - User Guide

Run Routines

User Interface > Run Routines

The results of all executed routines (procedures and functions) are shown in this view. You can rerun routines using the same arguments or view past results.

Button Option Description
Run Runs the routine using the argument values entered in the grid
Select Connection If you executed a routine with the same name from multiple connections, you can specify the connection from which the routine should be executed using this drop down menu
Show Results Displays the results of routines you executed in the past
Remove Execution Result Removes the current routine result from the view

SQL Monitor View

User Interface > SQL Monitor View

SQL Monitor

SQL Monitor displays all internal/user executed SQL queries as well as their execution time. Any queries that fail during the execution are commented out in the monitor and the error description is attached.

NOTE: Internal queries refer to queries automatically performed by Toad Edge during certain actions (e.g. viewing table data in Object Detail)

SQL Monitor is disabled by default and you will have to enable it by clicking the Enable/Disable Output button in order to monitor queries.

Button Option Description
Enable/Disable Output Enables/disables SQL query monitoring
Clear Console Deletes the contents of the view
Export Script Exports the contents of the view to a SQL file
Scroll Lock If enabled, your current position in the monitor is not changed even as new information is being displayed. Otherwise, the position changes to display the newest information
View Menu This menu allows you to enable/disable monitoring of internal/user queries

SQL Recall View

User Interface > SQL Recall View

SQL Recall

SQL Recall displays the last 100 executed SQL statements. The statements are grouped by connection and can be filtered and pinned. You can view the entire statement simply by selecting in the view. Double-clicking a statement will cause it to be pasted into the currently active Worksheet.

Button Option Description
Filter Filters the statements according to the input. It is possible to use wildcards (? and *) and regular expressions as well as filter by multiple comma separated values
Expand All Expands all connections to display their statements
Collapse All Collapses all connections, hiding all statements
Copy Copies the currently selected statement to clipboard. You can copy multiple statements at once
Hide Unpinned Entries Hides statements that are not pinned
Pin Entry Pins the selected statement(s) so they can be filtered using the option above
Delete All Deletes all statements from the view
Delete Deletes the selected statement(s) from the view

Session Browser

User Interface > Session Browser

The Session Browser displays database sessions and their state. The information is continuously updated and all changing values are highlighted. The sessions can be filtered and inactive sessions can be hidden. If the current user has sufficient privileges, it is also possible to terminate sessions.

To start monitoring sessions

  • Select a database connection from the Select Connection dropdown menu
  • The refresh period can be configured in the View Menu dropdown menu

To terminate a session

  • Select session that you want to terminate and then click the Kill Selected Session button

Toolbar button Name Description
Refresh Manual update of the status of all sessions
Select Connection Select a connection here in order to monitor its sessions
Hide Inactive Sessions Hides sessions that are currently not being active (e.g. sessions that are asleep)
Resize Columns to Data Resizes columns so they fit the values they contain
Kill Selected Session Terminates the selected session
View Menu Allows you to change the monitoring refresh period
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating