When clicking on the 'Locks' tab in the Session Browser, it seems to continually run and never bring back any results. If I cancel it then it crashes.
1) Select View | Options | Oracle | Optimizer hints.
2) Locate the "All other" drop down box. Select the appropriate hint /*+ RULE */ from the list.
3) Select "Apply" and "OK" to accept the changes.
4) Close Toad and restart the application for the changes to take affect.
5) If /*+ RULE */ does not help, please try the other hints in the dropdown as well.
