Print Thread
Page 1 of 2 1 2
Poor performance vs Oracle SQL Developer
#56934 08/24/17 01:53 PM
Joined: Jun 2017
Posts: 5
C
Corax Offline OP
Member
OP Offline
Member
C
Joined: Jun 2017
Posts: 5
Hello
I am having troubles with PL/SQL Developer on DB with many packages and data. Oracle SQL Developer works just fine.
I have tried all guidelines on this forum.
Thanks

Re: Poor performance vs Oracle SQL Developer
Corax #56940 08/25/17 08:58 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you let me know exactly when performance is poor? What kind of actions are you performing that are slow?


Marco Kalter
Allround Automations
Re: Poor performance vs Oracle SQL Developer
Marco Kalter #56941 08/25/17 09:56 AM
Joined: Jun 2017
Posts: 5
C
Corax Offline OP
Member
OP Offline
Member
C
Joined: Jun 2017
Posts: 5
Opening packages, just scrolling down the packages, data fetching

Re: Poor performance vs Oracle SQL Developer
Corax #56942 08/25/17 10:08 AM
Joined: Jun 2017
Posts: 5
C
Corax Offline OP
Member
OP Offline
Member
C
Joined: Jun 2017
Posts: 5
Executing statement

Re: Poor performance vs Oracle SQL Developer
Corax #56951 08/26/17 10:01 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 12\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 12).


Marco Kalter
Allround Automations
Re: Poor performance vs Oracle SQL Developer
Marco Kalter #57175 10/20/17 09:26 AM
Joined: Oct 2017
Posts: 16
K
kcl Offline
Member
Offline
Member
K
Joined: Oct 2017
Posts: 16
Hi

Was there any feedback regarding this? I'm seeing the same performance issues?

Regards,
Kenny

Re: Poor performance vs Oracle SQL Developer
kcl #57176 10/20/17 03:12 PM
Joined: Apr 2003
Posts: 517
Portland, OR, USA
M
Member
Offline
Member
M
Joined: Apr 2003
Posts: 517
Portland, OR, USA
Agreed - opening packages takes about 5 seconds compared to v11 opening in less than a second. Switching databases is slow. It's faster to close everything and open pl/sql developer again.

Re: Poor performance vs Oracle SQL Developer
mike #57183 10/23/17 08:42 AM
Joined: Nov 2007
Posts: 18
B
Member
Offline
Member
B
Joined: Nov 2007
Posts: 18
I stand with the decreasing (in negative sense) performance of plsql developer (coming from version 5.x).

Thought was the (distributed) environment
When writing some simple applications with lazarus and oracle components things truely fly. Even with xmltype/blobs, which really, really hurt in plsql developer when co-selected in queries.

Think performance and snappyness should be highest on the list for new version(s).

Last edited by Bart; 10/23/17 08:43 AM.
Re: Poor performance vs Oracle SQL Developer
Bart #57952 05/17/18 01:00 PM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
Member
Offline
Member
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
I agree with above members, performance of PL/SQL Developer has been degrading over the years and it would be on of my most favoured improvements if the developer could improve this.

That said, some things I did that improved responsiveness of PL/SQL Developer:
1) disabled the clipboard history. (preferences - editor - clipboard)
2) made sure nls_sort from backend and client matched(registry - Oracle home)




Certainty of death, small chance of succes,
What are we waiting for... (Gimly)
Re: Poor performance vs Oracle SQL Developer
koja #57956 05/17/18 04:42 PM
Joined: Jul 2004
Posts: 592
W
Member
Offline
Member
W
Joined: Jul 2004
Posts: 592
If we're sharing performance-increasing tips, mine is:
Turn off Preferences->Connection->Store recent history

My problems related to slow startup and connection-switching went away when I turned that setting off.

Page 1 of 2 1 2

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.136s Queries: 15 (0.056s) Memory: 2.5589 MB (Peak: 3.0403 MB) Data Comp: Off Server Time: 2024-05-17 00:28:12 UTC
Valid HTML 5 and Valid CSS