Trying to capture oracle session details like SQL Navigator spool window in TOAD.
This is the information needed:
-Session account logged on
-query/statement timestamps (start and stop)
-Query/statement SQL that was executed
-Count of affected rows.
WORKAROUND:
The best option is to use the SQL Spool (Database|Spool SQL).
We have created an Enhancement Request to add the starting timestamp and the number of rows affected to the SQL Spool.
STATUS:
Enhancement request CR ER 66744 has been submitted to Development for consideration in a future release of Toad For Oracle.
