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
Post Details
Added on Jul 5 2019
2 comments
122 views