"Compare User Objects" and "Export User Objects" is getting slower and slower with each version of PLSQL developer.
The following values ​​were obtained when comparing two databases:
8.0.4.1514 => 2 min 20 sec
10.0.5.1710 => 4 min 43 sec
12.0.7.1837 => 6 min 39 sec
Comparing tables and views is especially slow. Packages, functions, procedures even with thousends lines of code are compared very quick.
Objects in these two database:
COUNT OBJECT_TYPE
35 SEQUENCE
2 PROCEDURE
28 LOB
29 PACKAGE
28 PACKAGE BODY
1 TYPE BODY
59 TRIGGER
351 INDEX
205 TABLE
91 VIEW
10 SYNONYM
1 JAVA CLASS
1 JAVA SOURCE
4 FUNCTION
3 TYPE
3 JOB
Any ideas on how to achieve an acceptable Performance in PLSQL Developer 12. As a work-around I have installed old Version 8 in parallel to 12.
Regards
Can you let me know the database versions involved?
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
------------------
Regards
Frank
Can you confirm that issue?
Shall I generate a log with debug output?
------------------
Regards
Frank
I can confirm the same. It seems that views, especially, are processed very slowly.
We're looking into this.
© Allround Automations forums