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!

SQL Developer incredibly slow to load Application Schema ~15 minutes

498988Jan 9 2007 — edited Jan 12 2007
Hi, I am evaluating SQL Developer to see if it is a viable alternative to TOAD and although it compares favourably on it's functionality offering it is unusable when I try to connect to a remote applications database. It seems to attempt to load all PL/SQL objects from the remote server even if I am only opening a single procedure or package.

For example, if i want to view the packages in the apps schema then I expand the packages tree control in the connections browser. This takes ~15 minutes to complete! TOAD, while also slow, takes ~30 to 40 seconds.

This obviously makes the tool useless. Does anyone else get this problem?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2007
Added on Jan 9 2007
18 comments
4,103 views