Database Probe hangs and does not return information. Issue is with all 10g databases. In View | Options | Oracle | Optimizer Hints, the '/*+RULE*/' hint was selected for the "All Others" field.
Toad does not apply the hint on one particular background query. Performance issues with this query without the Oracle hint.
WORKAROUND:
Update database statistics as below:
BEGIN
SYS.DBMS_STATS.GATHER_DICTIONARY_STATS (
Granularity => 'DEFAULT'
,Options => 'GATHER'
,Estimate_Percent => NULL
,Method_Opt => NULL
,Degree => 4
,Cascade => FALSE
,No_Invalidate => FALSE);
END;
/
BEGIN
SYS.DBMS_STATS.GATHER_FIXED_OBJECTS_STATS (
No_Invalidate => FALSE);
END;
/
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
