Expanding the All Schemas node on the DB Navigator took 2-3 minutes for a 10g database.
WORKAROUND 1:
Run the following statements in the database having issues:
exec dbms_stats.gather_dictionary_stats;
exec dbms_stats.gather_fixed_objects_stats;
An SGA Flush is required before stats take effect
WORKAROUND 2:
Run the below commands in SQL Nav Editor window*:
alter session set "_COMPLEX_VIEW_MERGING" = false;
alter session set "_gby_hash_aggregation_enabled" = FALSE;
alter session set "_optimizer_cost_based_transformation" =off;
WORKAROUND 3:
Click the Filter button in DB Navigator toolbar; Switch to General tab in the Filter Properties dialog; Input % in to the edit above Delete and Add buttons and press Add to add it to the list; Input a name to the Filter Name edit and press Save button to save it; Press OK button to close the Filter Properties dialog; Now try to expand the All Schemas node in DB Navigator tree. It should take much less time.
*These commands can also be added to glogin.sql file of the Oracle client.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center