User goes into Schema Browser, right mouse clicks on a table, and selects Rebuild Table then Toad appears to hang.
The database maybe running slower than usual for the queries Toad executes. Let the query run for an hour to over night. Please check with your DBA and request that optimization be done or statistics be gathered on the database. Use the following test.
1. Launch Toad, open the Schema Browser.
2. Then go to the menu Database | Monitor | SQL Monitor.
3. In SQL Monitor, check the box for Toad.exe.
4. Now go back into Toad. Right mouse click on your table and select Rebuild Table.
5. Go through the Rebuild Table screen until it hangs.
6. Once it hangs, go back to SQL Monitor.
7. Investigate the last query that is ran. Test if it runs in SQL Plus.
The following suggestions may also help performance.
1. Launch Toad, go to View | Toad Options.
2. On the left, go to Oracle | Optimizer Hints.
3. At the bottom, there is a drop down menu for "All Others." Try selecting /*+RULE*/. Apply and OK.
4. Restart Toad. Retest the issue. See if it helps. If it doesn't try the other optimizer hints.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center