In Toad 10, when trying to Alter Index and select monitoring (under Basic Info tab) it does not create sql to run and gives the message that script is empty when you try to click OK. If the SQL (show sql button) is reviewed, the script is actually empty when its suppose to have something like:
ALTER INDEX testshm.ABC_01
MONITORING USAGE;
This is the same issue for both enabling or disabling monitoring. Other options like parallel,etc. dont have this problem.
There are no problems with 9.7.
WORKAROUND:
None. Manually run the command for monitoring.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
