Print Thread
9.x login, switch between open windows and general behavior very slow
#42502 10/20/11 12:59 PM
Joined: Oct 2011
Posts: 5
K
KaiAIM Offline OP
Member
OP Offline
Member
K
Joined: Oct 2011
Posts: 5
The login in 9.x is much slower than with 8.x
My backend is Oracle 11g and my client, too. This was the same configuration with 8.x, but with 9.x it is very slow.
But more painful is the slow switch between different windows, e.g. from on one open package to another or a sql window. This took at least 4 seconds which is a very long time when I want only to switch between two open windows. In the Debug.txt you can see a delay of 3 seconds where nothing happened (see red marked):
20.10.2011 14:46:01 NavigationBookmarks.EnableButtons(Rebuild)
20.10.2011 14:46:01 NavigationBookmarks: Backward=1, Forward=0
20.10.2011 14:46:01 AddNavigationBookmark starts
20.10.2011 14:46:01 AddNavigationBookmark GNV00002
20.10.2011 14:46:01 NavigationBookmarks.EnableButtons(Rebuild)
20.10.2011 14:46:01 NavigationBookmarks: Backward=2, Forward=0
20.10.2011 14:46:01 AddNavigationBookmark ends
20.10.2011 14:46:04 Lock
20.10.2011 14:46:04 Lock
20.10.2011 14:46:04 UnLock
20.10.2011 14:46:04 Lock
20.10.2011 14:46:04 UnLock
20.10.2011 14:46:04 UnLock
20.10.2011 14:46:04 NavigationBookmarks.EnableButtons(Rebuild)
20.10.2011 14:46:04 NavigationBookmarks: Backward=2, Forward=0
20.10.2011 14:46:04 UpdateChildList [timer]
20.10.2011 14:46:04 DoUpdateChildList
20.10.2011 14:46:04 Lock
20.10.2011 14:46:04 Lock
20.10.2011 14:46:04 UnLock
20.10.2011 14:46:04 UnLock

This behavior we didn't have with 8.x.

Also opening the package in a editor takes several seconds, in Oracle SQLDeveloper the same package body opens within one second.

In general all actions have become very slow. When I do the same (open table definition, open package body) with Oracle SQLDeveloper on the same database it is much faster, so the connection cannot be the problem.

The behavior is the same with Multiconnection On and Off.

Any Ideas?


Kai Gerhold
Re: 9.x login, switch between open windows and general behavior very slow
KaiAIM #42511 10/21/11 09:54 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you let me know your exact PL/SQL Developer version?


Marco Kalter
Allround Automations
Re: 9.x login, switch between open windows and general behavior very slow
Marco Kalter #42515 10/21/11 10:15 AM
Joined: Oct 2011
Posts: 5
K
KaiAIM Offline OP
Member
OP Offline
Member
K
Joined: Oct 2011
Posts: 5
PL/SQL Developer
Version 9.0.2.1621
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Parameters
C:\Programme\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Programme\PLSQL Developer\Preferences\Default\Default.ini
C:\Programme\PLSQL Developer\Preferences\<UserName>\default.ini

Plug-Ins
*Active Query Builder (C:\Programme\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Developer CompareSource Plug-In version 2003/12/03 (C:\Programme\PLSQL Developer\PlugIns\CompareSource.dll)
KPO Connection manager (C:\Programme\PLSQL Developer\PlugIns\KPConnectionManager.dll)
*PL/SQL Documentation (plsqldoc) (C:\Programme\PLSQL Developer\PlugIns\plsqldoc.dll)
Red Gate Deployment Plug-In (C:\Programme\PLSQL Developer\PlugIns\RedGate.dll)
SaveSeparate v2.0 (C:\Programme\PLSQL Developer\PlugIns\saveseparate.dll)
*User-defined Export 1.1 (C:\Programme\PLSQL Developer\PlugIns\TextExport.dll)
*TNSEditor Plugin (C:\Programme\PLSQL Developer\PlugIns\TNSEditorPlugin.dll)
*Version Control Interface 1.2 (C:\Programme\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Homes
Ora10g (C:\oracle)
OraClient11g_home1 (c:\app\<UserName>\product\11.2.0\client_1)

DLLs
c:\app\<UserName>\product\11.2.0\client_1\oci.dll

TNS File
c:\app\<UserName>\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: c:\app\<UserName>\product\11.2.0\client_1\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8



Kai Gerhold
Re: 9.x login, switch between open windows and general behavior very slow
KaiAIM #42522 10/24/11 09:31 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Thanks, we will check it out.


Marco Kalter
Allround Automations
Re: 9.x login, switch between open windows and general behavior very slow
Marco Kalter #42893 12/08/11 12:25 PM
Joined: Dec 2011
Posts: 2
M
Member
Offline
Member
M
Joined: Dec 2011
Posts: 2
Hello, I have similar problem. Is there any solution for this?

Re: 9.x login, switch between open windows and general behavior very slow
Maros #42906 12/09/11 10:10 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Are you using the current 9.0.3 version?


Marco Kalter
Allround Automations
Re: 9.x login, switch between open windows and general behavior very slow
Marco Kalter #42916 12/09/11 04:03 PM
Joined: May 2011
Posts: 1
B
Member
Offline
Member
B
Joined: May 2011
Posts: 1
I'm using 9.03 and also have this problem.

Re: 9.x login, switch between open windows and general behavior very slow
Boza #42919 12/09/11 09:56 PM
Joined: Dec 2011
Posts: 2
S
Member
Offline
Member
S
Joined: Dec 2011
Posts: 2
I have the same problem with 9.0.1.

Re: 9.x login, switch between open windows and general behavior very slow
KaiAIM #43620 03/23/12 03:05 AM
Joined: Mar 2012
Posts: 2
A
Member
Offline
Member
A
Joined: Mar 2012
Posts: 2
same problem with 9.0.6.1665


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.109s Queries: 14 (0.053s) Memory: 2.5396 MB (Peak: 3.0425 MB) Data Comp: Off Server Time: 2024-05-18 16:36:08 UTC
Valid HTML 5 and Valid CSS