Print Thread
"Compare User Objects" and "Export User Objects" gets slower with each version
#59380 01/15/19 05:11 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
"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

Re: "Compare User Objects" and "Export User Objects" gets slower with each version
FrankMUC #59387 01/16/19 10:23 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Can you let me know the database versions involved?


Marco Kalter
Allround Automations
Re: "Compare User Objects" and "Export User Objects" gets slower with each version
Marco Kalter #59399 01/17/19 10:50 AM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
------------------
Regards
Frank

Re: "Compare User Objects" and "Export User Objects" gets slower with each version
FrankMUC #59444 01/22/19 11:39 AM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
Can you confirm that issue?
Shall I generate a log with debug output?
------------------
Regards
Frank

Re: "Compare User Objects" and "Export User Objects" gets slower with each version
FrankMUC #59446 01/22/19 02:38 PM
Joined: Mar 2000
Posts: 204
Akron, OH, USA
Member
Offline
Member
Joined: Mar 2000
Posts: 204
Akron, OH, USA
I can confirm the same. It seems that views, especially, are processed very slowly.

Re: "Compare User Objects" and "Export User Objects" gets slower with each version
jlcox #59450 01/23/19 09:56 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
We're looking into this.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 15 (0.009s) Memory: 2.5167 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-04 12:22:33 UTC
Valid HTML 5 and Valid CSS