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.
|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 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.
|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 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.
|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|
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
To terminate a session
|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|