Table Constaints Tab Slowness (4234809)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Table Constaints Tab Slowness
Description

When selecting the Table | Contraints tab in the Schema Browser, it takes a long time to retreive the information.
Cause

Querying from sys.DBA_CONSTRAINTS is slow
Resolution

SOLUTION 1:
Follow the steps below to configure some Optimizer hints in the Toad options to speed up the query.
1. In Toad go to View | Toad Options | Oracle - Optimizer Hints.
2. On the right, from the "All Others" drop down menu. Select the "/*+RULE*/" hint and click Apply, then click OK to accept the changes.
3. Close Toad and then re-open and re-log on to your database.
4. Open a new Schema Browser, if it still takes a long time, go back to View | Options | Oracle | Optimizer Hints and try the next Optimizer hint. (/*+CHOOSE*/, /*+FIRST_ROWS*/, etc.)
5. Each time you try a new Optimizer hint, restart Toad again and then open a new

SOLUTION 2:

Use SQL Tracker to trace what query is running slow on your database to tune it.

1. Log into your problem database.
2. Open Schema Browser | Tables tab
3. Go to Database | Monitor | and launch SQL Tracker
4. In SQL Tracker, click on Toad.exe and hit the green play button to start the tracking
5. Go back into Toad and click on the Constraints tab
6. Go to SQL Tracker and see what query Toad is running the background that is causing the slowness.
7. Take the query or queries and run it in SQLPlus or Toad's Editor to determine which query is slow.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title