Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unfolding filtered Package list in Connections navigator/DDL Extraction - terribly slow

LPNOJul 5 2019 — edited Jul 26 2019

SQL Developer, Version 18.4.0.376

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

For a view days the unfolding the package list in the connections navigator is terribly slow. The filter results in two packages, but I have to wait 3min+ instead of a few seconds.

Till a few weeks ago, this has been significantly faster.

What may be the reasons for this declined performance?

I think in TOAD DDL-DESCRIBE with F4 declined in it's speed, too.

Not sure if this is a problem of SQL developer or of my DB system. When I get to a recently cloned test-System., this is slow, too. An older test system is as fast as expected.

Can I do something to generally speed up DDL-Extractions in the target DB-system?

This post has been answered by thatJeffSmith-Oracle on Jul 5 2019
Jump to Answer

Comments

thatJeffSmith-Oracle
Answer

make sure your data dictionary stats are up to date

Marked as Answer by LPNO · Sep 27 2020
LPNO

Thanks, this was the issue.

begin

    dbms_stats.gather_fixed_objects_stats;

    dbms_stats.gather_dictionary_stats;

end;

It helped, I'm going the schedule this.

1 - 2

Post Details

Added on Jul 5 2019
2 comments
121 views