While using the Object Search in TOAD with only one specific Schema/Owner selected, the search completes within a few seconds. When running the same search against a different specific Schema/Owner, it also completes within a few seconds. However, when choosing both those same two Schema/Owners at the same time and run the search, it takes more than an hour
Searching with Schema/Owner = * ALL USERS EXCEPT SYS/SYSTEM is also very slow.
Please add an optimize hint to the ALL_OBJECT and ALL_SOURCE views to see if this improves the speed of your search. Here is how to add the hints:
1) Go to View|Options|Oracle-Optimizer Hints.
2) Check the edit box.
3) Click the "+" sign on top right of window.
4) Typed view name into first column.
5) Selected appropriate selection from middle column.
6) Choose /*RULE*/ from drop down in third column.
8) Click Apply
9) Click OK.
10) Go back into options to make sure it saved.
