Is there anyway in Toad or outside of Toad to track the progress of a long running query?
In Toad, once a query is run, wait for minutes or hours before it returns, not knowing if something is happening on the database end or has just hung.
Is there a way to check if there is any activity on the database end (Check for dynamic sampling or anything in the Session browser on a long running query) so if there is no activity, the session can be killed?
Is there any info on where to look for any activities on the database end, % complete of the job, any query on the sys schema for status on long running query?