How do I use Spool SQL feature to monitor SQL statements running in Toad's background processes?
See video tutorial below:
Steps to Spool SQL
Note: At any given time you can use the Spool SQL feature.
Spool SQL to File:
1. Go to Database | Spool SQL | Spool SQL to File
2. Perform your task
3. The results are in a text file call Debug.sql located in your User Files directory
NOTE: Go to View | Toad Options | General | Application Data Path if you do not know the User Files directory
Spool SQL to Screen:
1. Go to Database | Spool SQL | Spool SQL to Screen
2. Perform your task
3. The results should be in the output window within Toad's Output | Spool SQL tab
See Video Tutorial.
