Return
-
Title
Schema browser returns information faster when DBA user -
Description
When looking at other schema in the schema browser, if I have DBA privileges then the information returns right away, but if I do not have DBA privileges it takes several minutes to return the information. What is causing the different in times to return the information?
-
Cause
When using the schema browser to view another schema's tables, as a standard user, ALL_ALL_TABLES is being queried. As a DBA, DBA_ALL_TABLES is being queried. For some reason, there is a tremendous difference in response time depending on the view used.
-
Resolution
Try gathering statistics on your database.
-
Additional Information
This is a database issue. if you run the query Toad is using to gather the information in SQLplus you will see the difference in performance as well.