In the Session Browser, I have the Refresh box checked and set auto refresh time of 5 sec. How come the Session Browser is not refreshing the info in the Current Statement?
RESOLUTION 1:
Make sure you have Fetch details box checked.
RESOLUTION 2:
1. If Fetch details is checked and it doesnt help, run a SQL Monitor trace by going to Database | Monitor | SQL Monitor.
2. Check the appropriate Toad.exe instance in the SQL Monitor.
3. As a test, set the refresh rate for the Session Browser to 5 sec.
4. Check the SQL Monitor to see if code is generate every 5 seconds.
If SQL Monitor is pushing out code, check your rights to V$SESSION table. If SQL Monitor is not pushing out code, open a case via SupportLink for further investigation.
