-
Title
Spooling SQL from remote session -
Description
Is there any method available to spool all SQL statements from a session running on a remote server, much like the snapshot available in session browser (current statement) but rolling and storing all statements sent?
SQL Tracker seems to achieve a similar output but it only works with applications on the PC it is installed on.
-
Resolution
1. Go to Database | Monitor | Session Browser
2. Right-click on the session you want to monitor and select "Start Trace". You can read more about Tracing from the help file "Trace Sessions"
3. Once you are done tracing, right-click and Stop Trace
4. Go to Database | Diagnose | Trace File Browser | Now locate the trace file from your server and FTP it to your local machine. You can now view the statements of the session via the Trace File Browser. Check with your Oracle documentation on how to find the trace file specific to the Oracle version.