- Windows 7 client
- Toad 184.108.40.206
- DBA Module
- 220.127.116.11 database on a Windows 2008 Azure server, in the cloud.
In the session browser, database->monitor->Session Browser, I’m watching an impdp session with 8 parallel slaves - DW00 through DW07. In order to see those, I have to remove the filter to “Exclude NULL and SYSTEM OS Users”.
As soon as I click Refresh, or as soon as the timer refreshes, all the sessions in the tree on the left side, expand and turn cyan.
Steps to reproduce:
- Open Session Browser;
- Click the filter and unselect “Exclude NULL and SYSTEM OS Users”. (Nothing is now ticked);
- The refresh checkbox can be checked or unchecked.
- Click on one (or more) of the ‘+’ beside the program name to monitor - I’m using DW00, but anything at all works, provided, it’s a SYSTEM or background process. The program name will be ORACLE.EXE (xxxx)(n) where ‘xxxx’ is the background task name and ‘n’ is the number of processes.
- Wait …
If the screen is set up to refresh every few seconds, on the next refresh, all the background processes named “oracle.exe (xxxx)(n)” will effectively “expand all”. If the screen is not set up to auto-refresh, just click on the refresh button (two green arrows pointing in a circle) and again, all the background sessions will “expand all”. It’s terribly annoying!
I suspect this might be fixed in some patch or other released after my version, but unfortunately, I’m not up to date here. Sigh.