PL/SQL Developer - Poor performance

[Shivu]

PL/SQL Developer tool is taking long time to respond on Citrix. Kindly assist us, How to resolve it?

When I login & click screen goes blank for 50 secs

Version : 11.0.2.17

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

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

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[Shivu]

Kindly find the below information from the debug.txt file

PL/SQL xxxxeloper
Version 11.0.2.1766
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.194.304 kB (4.194.304 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.968.128 available)

Parameters
C:\xxxxgram Files (x86)\PLSQL xxxxeloper\plsqlxxxx.exe
DebugSQL

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

Preference Files

Debug file
C:\xxxxgram Files (x86)\PLSQL xxxxeloper\PlSqlxxxx.elf

Plug-Ins

Monitor
Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1200

MainFormOnTaskbar = False

02.03.2016 16:57:33 Application started

00:00:00.003 InitPreferences
00:00:00.003 Load C:\xxxxgram Files (x86)\PLSQL xxxxeloper\Preferences\Default = 0
00:00:00.004 PreferenceSet.Load C:\xxxxgram Files (x86)\PLSQL xxxxeloper\Preferences\Default\Default.ini
00:00:00.005 PreferenceSet.Load OK
00:00:00.005 Determine LocalPrefPath
00:00:00.006 [1]: C:\Users\abc\AppData\Roaming\PLSQL xxxxeloper\Preferences
00:00:00.007 LocalPrefPath: C:\Users\abc\AppData\Roaming\PLSQL xxxxeloper\Preferences\abc
00:00:00.007 Load C:\Users\abc\AppData\Roaming\PLSQL xxxxeloper\Preferences\abc = 0
00:00:00.007 PreferenceSet.Load C:\Users\abc\AppData\Roaming\PLSQL xxxxeloper\Preferences\abc\default.ini
00:00:00.008 PreferenceSet.Load OK
00:00:00.008 PreferenceSet.Load C:\Users\abc\AppData\Roaming\PLSQL xxxxeloper\Preferences\abc\user.prefs
00:00:00.009 PreferenceSet.Load OK
00:00:00.009 InitPreferences end
00:00:00.010 SortPreferenceSets
00:00:00.010 - Default abc
00:00:00.011 - System Default
00:00:00.064 DoUpdateChildList starts
00:00:00.092 Lock
00:00:00.093 UnLock
00:00:00.104 FindPassword starts for abc[xyz]@xxxxject_xxxx
00:00:00.104 Check current connections...
00:00:00.104 Check connection definitions...
00:00:00.105 FindPassword ends for abc[xyz]@xxxxject_xxxx, no result
00:00:00.105 FindPassword starts for abc[xyz]@MSP11QUA
00:00:00.105 Check current connections...
00:00:00.105 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.106 Check connection definitions...
00:00:00.106 FindPassword ends for abc[xyz]@MSP11QUA, no result
00:00:00.106 FindPassword starts for abc[xyz]@msp11xxxx
00:00:00.107 Check current connections...
00:00:00.107 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.107 Checking abc[xyz]@MSP11QUA...
00:00:00.107 Check connection definitions...
00:00:00.108 FindPassword ends for abc[xyz]@msp11xxxx, no result
00:00:00.108 FindPassword starts for xxx[xyz]@MSP11xxxx
00:00:00.108 Check current connections...
00:00:00.109 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.109 Checking abc[xyz]@MSP11QUA...
00:00:00.110 Checking abc[xyz]@msp11xxxx...
00:00:00.110 Check connection definitions...
00:00:00.110 FindPassword ends for xxx[xyz]@MSP11xxxx, no result
00:00:00.111 FindPassword starts for xxx[xyz]@MSP11xxxx
00:00:00.111 Check current connections...
00:00:00.112 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.112 Checking abc[xyz]@MSP11QUA...
00:00:00.112 Checking abc[xyz]@msp11xxxx...
00:00:00.113 Checking xxx[xyz]@MSP11xxxx...
00:00:00.113 Check connection definitions...
00:00:00.113 FindPassword ends for xxx[xyz]@MSP11xxxx, no result
00:00:00.114 FindPassword starts for abc[xyz]@xxxxject_xxxx
00:00:00.114 Check current connections...
00:00:00.114 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.115 Checking abc[xyz]@MSP11QUA...
00:00:00.115 Checking abc[xyz]@msp11xxxx...
00:00:00.115 Checking xxx[xyz]@MSP11xxxx...
00:00:00.116 Checking xxx[xyz]@MSP11xxxx...
00:00:00.116 Check connection definitions...
00:00:00.116 FindPassword ends for abc[xyz]@xxxxject_xxxx, no result
00:00:00.117 FindPassword starts for xxx[xyz]@MSP11xxxx
00:00:00.117 Check current connections...
00:00:00.117 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.118 Checking abc[xyz]@MSP11QUA...
00:00:00.118 Checking abc[xyz]@msp11xxxx...
00:00:00.119 Checking xxx[xyz]@MSP11xxxx...
00:00:00.119 Checking xxx[xyz]@MSP11xxxx...
00:00:00.119 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.120 Check connection definitions...
00:00:00.120 FindPassword ends for xxx[xyz]@MSP11xxxx , no result
00:00:00.120 FindPassword starts for abc[xyz]@xxxxject_xxxx
00:00:00.121 Check current connections...
00:00:00.121 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.121 Checking abc[xyz]@MSP11QUA...
00:00:00.121 Checking abc[xyz]@msp11xxxx...
00:00:00.122 Checking xxx[xyz]@MSP11xxxx...
00:00:00.122 Checking xxx[xyz]@MSP11xxxx...
00:00:00.122 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.123 Checking xxx[xyz]@MSP11xxxx ...
00:00:00.123 Check connection definitions...
00:00:00.124 FindPassword ends for abc[xyz]@xxxxject_xxxx, no result
00:00:00.124 FindPassword starts for abc[adm_sys]@xxxxject_xxxx
00:00:00.124 Check current connections...
00:00:00.125 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.125 Checking abc[xyz]@MSP11QUA...
00:00:00.125 Checking abc[xyz]@msp11xxxx...
00:00:00.126 Checking xxx[xyz]@MSP11xxxx...
00:00:00.126 Checking xxx[xyz]@MSP11xxxx...
00:00:00.126 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.126 Checking xxx[xyz]@MSP11xxxx ...
00:00:00.127 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.127 Check connection definitions...
00:00:00.127 FindPassword ends for abc[adm_sys]@xxxxject_xxxx, no result
00:00:00.128 FindPassword starts for abc[xyz]@xxxxject_qua2
00:00:00.128 Check current connections...
00:00:00.128 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.128 Checking abc[xyz]@MSP11QUA...
00:00:00.129 Checking abc[xyz]@msp11xxxx...
00:00:00.129 Checking xxx[xyz]@MSP11xxxx...
00:00:00.129 Checking xxx[xyz]@MSP11xxxx...
00:00:00.130 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.130 Checking xxx[xyz]@MSP11xxxx ...
00:00:00.130 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.131 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:00.131 Check connection definitions...

00:00:00.267 Checking abc[xyz]@xxxxject_tst...
00:00:00.267 Checking abc[xyz]@xxxxject_EDU2...
00:00:00.267 Checking abc[xyz]@xxxxject_12c...
00:00:00.268 Checking abc@xxxxject_xxxx...
00:00:00.268 Checking abc@xxxxject_xxxx...
00:00:00.268 Checking abc@xxxxject_12c...
00:00:00.268 Checking abc@xxxxject_RBEI...
00:00:00.269 Checking abc[xyz]@xxxxject_xxxx2...
00:00:00.269 Checking abc[xyz]@xxxxject_RBEI...
00:00:00.269 Checking abc[xyz]@xxxxject_CIS...
00:00:00.270 Checking xxx[xyz]@xxxxject_EDU2...
00:00:00.270 Checking abc[xyz]@xxxxject_perf...
00:00:00.270 Checking abc[xyz]@xxxxject_MIG2...
00:00:00.270 Checking abc[xyz]@xxxxject_tst2...
00:00:00.271 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:00.271 Checking abc[xyz]@xxxxject_ITF...
00:00:00.272 Check connection definitions...
00:00:00.272 FindPassword ends for aag1kor[xyz]@xxxxject_xxxx, no result
00:00:00.272 FindPassword starts for aag1kor[xyz]@xxxxject_xxxx
00:00:00.273 Check current connections...
00:00:00.273 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.273 Checking abc[xyz]@MSP11QUA...
00:00:00.273 Checking abc[xyz]@msp11xxxx...
00:00:00.274 Checking xxx[xyz]@MSP11xxxx...
00:00:00.274 Checking xxx[xyz]@MSP11xxxx...
00:00:00.274 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.274 Checking xxx[xyz]@MSP11xxxx ...
00:00:00.275 Checking abc[xyz]@xxxxject_xxxx...
00:00:00.275 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:00.275 Checking abc[xyz]@xxxxject_qua2...
00:00:00.275 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:00.276 Checking xxx[xyz]@xxxxject_TST2...
00:00:00.276 Checking abc[xyz]@xxxxject_qua...
00:00:00.276 Checking abc[xyz]@xxxxject_tst...
00:00:00.277 Checking abc[xyz]@xxxxject_EDU2...
00:00:00.277 Checking abc[xyz]@xxxxject_12c...
00:00:00.277 Checking abc@xxxxject_xxxx...
00:00:00.277 Checking abc@xxxxject_xxxx...
00:00:00.278 Checking abc@xxxxject_12c...
00:00:00.278 Checking abc@xxxxject_RBEI...
00:00:00.278 Checking abc[xyz]@xxxxject_xxxx2...
00:00:00.278 Checking abc[xyz]@xxxxject_RBEI...
00:00:00.279 Checking abc[xyz]@xxxxject_CIS...
00:00:00.279 Checking xxx[xyz]@xxxxject_EDU2...
00:00:00.279 Checking abc[xyz]@xxxxject_perf...
00:00:00.279 Checking abc[xyz]@xxxxject_MIG2...
00:00:00.280 Checking abc[xyz]@xxxxject_tst2...
00:00:00.280 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:00.280 Checking abc[xyz]@xxxxject_ITF...
00:00:00.281 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:00.281 Check connection definitions...
00:00:00.281 FindPassword ends for aag1kor[xyz]@xxxxject_xxxx, no result
00:00:00.282 pfReadRegistry(PL/SQL xxxxeloper\Shell\Open\Command, )
00:00:00.282 ReadString OK
00:00:00.283 pfReadRegistry: "C:\xxxxgram Files (x86)\PLSQL xxxxeloper\PLSQLxxxx.exe" "%1"
00:00:00.295 Splash: Starting PL/SQL xxxxeloper
00:00:00.297 Splash: Version 11.0.2.1766
00:00:00.298 LoadPreferences
00:00:00.298 LoadPreferences searching for default
00:00:00.298 C:\Users\abc\AppData\Roaming\PLSQL xxxxeloper\Preferences\abc\default.ini
00:00:00.299 LoadPreferences NewPref := nil
00:00:00.299 LoadPreferences
00:00:00.299 LoadPreferences Reading preferences
00:00:00.300 Splash: Reading preferences
00:00:00.326 LoadPreferences ReadPosition
00:00:00.327 LoadPreferences ToolsBrowserItemClick(nil)
00:00:00.329 LoadPreferences CreateBrowserFilters...
00:00:00.330 LoadPreferences Files
00:00:00.330 LoadPreferences Printer
00:00:00.331 LoadPreferences FileBrowserFolders
00:00:00.331 LoadPreferences Connections
00:00:00.331 LoadPreferences BrowserFolders
00:00:00.332 LoadPreferences
00:00:00.333 LoadPreferences end
00:00:00.424 MacroLibFilename: C:\xxxxgram Files (x86)\PLSQL xxxxeloper\Macro\abc.emlib
00:00:00.457 Splash: Reading keywords
00:00:00.472 Logging on..
00:00:00.473 Creating new session
00:00:00.473 Initializing new session
00:00:00.473 Setting new session parameters
00:00:00.474 Setting logon session
00:00:00.474 OCI Initialization starts
00:00:00.478 OCI Initialization done
00:00:00.479 OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\Oracle\Cli11gR2_32\
Found: oci.dll
Using: C:\Oracle\Cli11gR2_32\bin\oci.dll
00:00:00.479 Logon2 starting
00:00:00.479 Logon2.Execute starts
00:00:26.751 TOracleSession $031A42E0 Start Session.LogOn as abc[xyz]@xxxxject_xxxx
00:00:36.275 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
00:00:36.281 TOracleQuery Query End (1 record xxxxcessed)
Duration = 0
00:00:36.281 TOracleSession $031A42E0 End
Duration = 9,532
00:00:36.283 Logon2.Execute done
00:00:36.283 Logon2 done
00:00:36.284 TOracleQuery $0AA0C020 Start Query.Execute
SQL = select sys_context('userenv', 'current_schema') from dual
00:00:36.285 TOracleQuery $0AA0C020 End (1 record xxxxcessed)
Duration = 0
00:00:36.286 TOracleSession $031A3D20 Start Session.LogOn as abc[xyz]@xxxxject_xxxx
00:00:45.651 TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
00:00:45.653 TOracleQuery Query End (1 record xxxxcessed)
Duration = 0
00:00:45.653 TOracleSession $031A3D20 End
Duration = 9,376
00:00:45.660 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
00:00:45.661 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
00:00:45.661 TOracleQuery Query End (5 records xxxxcessed)
Duration = 0
00:00:45.661 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = select grantee, name from
sys.plsqlxxxx_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
00:00:45.663 TOracleQuery BytesPerCharacterQuery End (1 record xxxxcessed)
Duration = 0
00:00:45.663 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
00:00:45.674 TOracleQuery $0AA0C2E0 End
Result = ORA-00942: table or view does not exist
Duration = 0,015
00:00:45.675 TOracleQuery BytesPerCharacterQuery End (1 record xxxxcessed)
Duration = 0,015
00:00:45.675 TOracleQuery $055DC610 Start Query.Execute
SQL = /*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL xxxxeloper installation directory for all users,
or in the "%APPDATA%\PLSQL xxxxeloper" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'xxxxCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = xyz
00:00:45.676 LogonHistorySave start
00:00:45.676 ChangeUserPref LogonHistory,
00:00:45.676 ChangeUserPref end
00:00:45.677 ChangeUserPref DSA,
00:00:45.677 ChangeUserPref end
00:00:45.678 ChangeUserPref ColumnAssociations,
00:00:45.678 ChangeUserPref end
00:00:45.678 ChangeUserPref ImportAssociations,
00:00:45.679 ChangeUserPref end
00:00:45.679 ChangeUserPref BrowserFilters,
00:00:45.679 ChangeUserPref end
00:00:45.680 ChangeUserPref FileBrowserFolders,
00:00:45.680 ChangeUserPref end
00:00:45.680 ChangeUserPref Connections,
00:00:45.680 ChangeUserPref end
00:00:45.681 ChangeUserPref BrowserFolders,
00:00:45.682 ChangeUserPref end
00:00:45.682 ChangeUserPref SessionQueries,
00:00:45.683 ChangeUserPref end
00:00:45.683 ChangeUserPref ExternalTools,
00:00:45.684 ChangeUserPref end
00:00:45.684 ChangeUserPref Documents,
00:00:45.684 ChangeUserPref end
00:00:45.685 ChangeUserPref WebSearches,
00:00:45.685 ChangeUserPref end
00:00:45.685 ChangeUserPref Reports,
00:00:45.686 ChangeUserPref end
00:00:45.686 ChangeUserPref CurrentConnections,
00:00:45.686 ChangeUserPref end
00:00:45.687 PreferenceSet.Save
00:00:45.687 PreferenceSet Filename = C:\Users\abc\AppData\Roaming\PLSQL xxxxeloper\Preferences\abc\user.prefs
00:00:45.688 PreferenceSet AltFile = user.prefs
00:00:45.689 PreferenceSet.Save end
00:00:45.689 LogonHistorySave end
00:00:45.690 Splash: connected
00:00:45.690 FormCreate Logon.Executed -1
00:00:45.690 FormCreate SessionChanged
00:00:45.691 TOracleQuery Query Start Query.Execute
SQL = select * from v$version
00:00:45.692 TOracleQuery Query End (5 records xxxxcessed)
Duration = 0
00:00:45.692 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID')
00:00:45.704 TOracleQuery $0AA0C2E0 End (1 record xxxxcessed)
Duration = 0,016
00:00:45.704 SessionChanged SetDBAViews
00:00:45.705 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
00:00:45.707 TOracleQuery $0AA0C2E0 End (0 records xxxxcessed)
Duration = 0
00:00:45.707 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
00:00:45.708 TOracleQuery $0AA0C2E0 End (0 records xxxxcessed)
Duration = 0
00:00:45.709 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
00:00:45.710 TOracleQuery BytesPerCharacterQuery End (1 record xxxxcessed)
Duration = 0
00:00:45.710 TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select lengthb(nchr(20)), nchr(20) from dual
00:00:45.712 TOracleQuery BytesPerCharacterQuery End (1 record xxxxcessed)
Duration = 0
00:00:45.718 SessionChanged Authorizations.Load
00:00:45.718 SessionChanged EnableAuthorizedMenus
00:00:45.718 WindowAllowed(1)
00:00:45.719 WindowAllowed done
00:00:45.719 WindowAllowed(1)
00:00:45.719 WindowAllowed done
00:00:45.720 ExecuteConnectScript starts
00:00:45.720 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = alter session set plsql_optimize_level = 2
00:00:45.721 TOracleQuery $0AA0C2E0 End
Duration = 0
00:00:45.721 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = alter session set plsql_code_type = interpreted
00:00:45.722 TOracleQuery $0AA0C2E0 End
Duration = 0
00:00:45.723 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = alter session set plscope_settings = 'identifiers:none'
00:00:45.723 TOracleQuery $0AA0C2E0 End
Duration = 0
00:00:45.724 ExecuteConnectScript ends
00:00:45.724 SetSessionAction starts: Primary Session
00:00:45.724 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = select null from dual
00:00:45.725 TOracleQuery $0AA0C2E0 End (1 record xxxxcessed)
Duration = 0
00:00:45.726 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL xxxxeloper', :action); end;
:ACTION = Primary Session
00:00:45.727 TOracleQuery $0AA0C2E0 End
Duration = 0
00:00:45.727 SetSessionAction ends
00:00:45.743 SessionChanged LoadRecentObjects
00:00:45.746 SessionChanged Logoff secondary sessions
00:00:45.746 SessionChanged EnableChildFunctions
00:00:45.747 SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient11g_home1
OracleHomeDir: C:\Oracle\Cli11gR2_32\
Found: oci.dll
Using: C:\Oracle\Cli11gR2_32\bin\oci.dll
00:00:45.747 SessionChanged Notify children
00:00:45.748 Lock
00:00:45.748 UnLock
00:00:45.749 UpdateChildList starts
00:00:45.761 TOracleQuery $055DC610 End (1 record xxxxcessed)
Duration = 0,094
00:00:45.762 TOracleQuery $055DC610 Start Query.Execute
SQL =
select s.synonym_name as object_name, o.object_type
from all_synonyms s, sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'xxxxCEDURE', 'FUNCTION', 'SEQUENCE')
:SCHEMA = xyz
00:00:45.991 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,218
00:00:45.992 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:45.994 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:45.995 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:45.997 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:45.998 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.000 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.001 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.003 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.004 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.005 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.006 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.008 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.009 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.011 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.012 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.014 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.015 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.016 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.017 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.019 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.020 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.022 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.023 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.025 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,015
00:00:46.026 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.027 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.029 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.033 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.034 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.036 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.038 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.040 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,016
00:00:46.041 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.043 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.044 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.052 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.053 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.055 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.056 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.060 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.061 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.066 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.067 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.071 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.072 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.074 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.075 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.080 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.081 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.083 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.085 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.087 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,016
00:00:46.088 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.096 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.097 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.100 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.101 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.104 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,015
00:00:46.105 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.124 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,016
00:00:46.125 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.129 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0
00:00:46.130 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.323 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,203
00:00:46.324 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.352 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,031
00:00:46.353 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.450 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,093
00:00:46.451 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.645 TOracleQuery $055DC610 End (100 records xxxxcessed)
Duration = 0,188
00:00:46.648 TOracleQuery $055DC610 Start Query.Next for up to 100 records
00:00:46.922 TOracleQuery $055DC610 End (21 records xxxxcessed)
Duration = 0,265
00:00:46.923 TOracleQuery $055DC610 Start Query.Execute
SQL =
select db_link as object_name, 'DATABASE LINK' as object_type
from sys.all_db_links o
where o.owner = :schema
or o.owner = 'PUBLIC'
:SCHEMA = xyz
00:00:46.925 TOracleQuery $055DC610 End (0 records xxxxcessed)
Duration = 0
00:00:46.925 TOracleSession $031A3D20 Start Session.LogOff
00:00:46.928 TOracleSession $031A3D20 End
Duration = 0
00:00:47.645 Splash: .
00:00:48.159 SortPreferenceSets
00:00:48.159 - Default abc
00:00:48.160 - System Default
00:00:48.264 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
00:00:48.266 TOracleQuery $0AA0C2E0 End (0 records xxxxcessed)
Duration = 0
00:00:48.267 TOracleQuery $0AA0C2E0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
00:00:48.268 TOracleQuery $0AA0C2E0 End (0 records xxxxcessed)
Duration = 0
00:00:48.268 Lock
00:00:48.269 UnLock
00:00:48.280 Adding new connection
00:00:48.281 Username = abc[xyz]
00:00:48.281 Database = xxxxject_xxxx
00:00:48.282 Adding new connection
00:00:48.282 Username = abc[xyz]
00:00:48.282 Database = xxxxject_xxxx
00:00:48.283 Adding new connection
00:00:48.283 Username = abc[xyz]
00:00:48.283 Database = MSP11QUA
00:00:48.284 Adding new connection
00:00:48.284 Username = abc[xyz]
00:00:48.284 Database = msp11xxxx
00:00:48.285 Adding new connection
00:00:48.285 Username = xxx[xyz]
00:00:48.285 Database = MSP11xxxx
00:00:48.286 Adding new connection
00:00:48.287 Username = xxx[xyz]
00:00:48.287 Database = MSP11xxxx
00:00:48.287 Adding new connection
00:00:48.288 Username = abc[xyz]
00:00:48.288 Database = xxxxject_xxxx
00:00:48.289 Adding new connection
00:00:48.289 Username = xxx[xyz]
00:00:48.289 Database = MSP11xxxx
00:00:48.290 Adding new connection
00:00:48.290 Username = abc[adm_sys]
00:00:48.290 Database = xxxxject_xxxx
00:00:48.291 Adding new connection
00:00:48.292 Username = abc[xyz]
00:00:48.292 Database = xxxxject_qua2
00:00:48.293 Adding new connection
00:00:48.293 Username = xxx[xyz]
00:00:48.293 Database = xxxxject_xxxx2
00:00:48.294 Adding new connection
00:00:48.294 Username = xxx[xyz]
00:00:48.294 Database = xxxxject_TST2
00:00:48.295 Adding new connection
00:00:48.295 Username = abc[xyz]
00:00:48.296 Database = xxxxject_qua
00:00:48.296 Adding new connection
00:00:48.297 Username = abc[xyz]
00:00:48.297 Database = xxxxject_tst
00:00:48.298 Adding new connection
00:00:48.298 Username = abc[xyz]
00:00:48.298 Database = xxxxject_EDU2
00:00:48.299 Adding new connection
00:00:48.300 Username = abc[xyz]
00:00:48.300 Database = xxxxject_12c
00:00:48.301 Adding new connection
00:00:48.301 Username = abc
00:00:48.301 Database = xxxxject_xxxx
00:00:48.303 Adding new connection
00:00:48.303 Username = abc
00:00:48.303 Database = xxxxject_xxxx
00:00:48.304 Adding new connection
00:00:48.304 Username = abc
00:00:48.305 Database = xxxxject_12c
00:00:48.306 Adding new connection
00:00:48.306 Username = abc
00:00:48.306 Database = xxxxject_RBEI
00:00:48.307 Adding new connection
00:00:48.308 Username = abc[xyz]
00:00:48.308 Database = xxxxject_xxxx2
00:00:48.309 Adding new connection
00:00:48.309 Username = abc[xyz]
00:00:48.309 Database = xxxxject_RBEI
00:00:48.310 Adding new connection
00:00:48.311 Username = abc[xyz]
00:00:48.311 Database = xxxxject_CIS
00:00:48.312 Adding new connection
00:00:48.313 Username = xxx[xyz]
00:00:48.313 Database = xxxxject_EDU2
00:00:48.314 Adding new connection
00:00:48.314 Username = abc[xyz]
00:00:48.315 Database = xxxxject_perf
00:00:48.317 Adding new connection
00:00:48.317 Username = abc[xyz]
00:00:48.317 Database = xxxxject_MIG2
00:00:48.319 Adding new connection
00:00:48.319 Username = abc[xyz]
00:00:48.319 Database = xxxxject_tst2
00:00:48.321 Adding new connection
00:00:48.321 Username = abc[prx_sys]
00:00:48.321 Database = xxxxject_xxxx
00:00:48.322 Adding new connection
00:00:48.323 Username = abc[xyz]
00:00:48.323 Database = xxxxject_ITF
00:00:48.324 Adding new connection
00:00:48.324 Username = aag1kor[xyz]
00:00:48.325 Database = xxxxject_xxxx
00:00:48.326 Adding new connection
00:00:48.326 Username = aag1kor[xyz]
00:00:48.327 Database = xxxxject_xxxx
00:00:48.344 DoUpdateChildList starts
00:00:48.345 Lock
00:00:48.345 UnLock
00:00:48.444 FormShow Starts
00:00:48.445 Splash: Loading Desktop
00:00:48.445 LoadDesktop starts
00:00:48.446 LoadDesktop DoUpdateChildList starts
00:00:48.446 DoUpdateChildList starts
00:00:48.446 LoadDesktop DoUpdateChildList ends
00:00:48.447 LoadDesktop ends
00:00:48.448 Splash: Finished
00:00:48.449 FormActivate start
00:00:48.472 FormActivate end
00:00:48.472 FormShow Ends
00:00:48.477 FormActivate start
00:00:48.477 FormActivate done
00:00:48.495 WMUpdatePopups starts
00:00:48.527 DoUpdateChildList starts
00:00:48.528 DoUpdateChildList Lock
00:00:48.528 Lock
00:00:48.529 UnLock
00:00:48.540 DoUpdateChildList UnLock
00:00:48.540 DoUpdateChildList ends
00:00:48.573 Adding new connection
00:00:48.574 Username = abc[xyz]
00:00:48.574 Database = xxxxject_xxxx
00:00:48.574 Adding new connection
00:00:48.575 Username = abc[xyz]
00:00:48.575 Database = xxxxject_xxxx
00:00:48.575 Adding new connection
00:00:48.576 Username = abc[xyz]
00:00:48.576 Database = MSP11QUA
00:00:48.576 Adding new connection
00:00:48.577 Username = abc[xyz]
00:00:48.577 Database = msp11xxxx
00:00:48.577 Adding new connection
00:00:48.578 Username = xxx[xyz]
00:00:48.578 Database = MSP11xxxx
00:00:48.579 Adding new connection
00:00:48.579 Username = xxx[xyz]
00:00:48.579 Database = MSP11xxxx
00:00:48.580 Adding new connection
00:00:48.580 Username = abc[xyz]
00:00:48.580 Database = xxxxject_xxxx
00:00:48.581 Adding new connection
00:00:48.581 Username = xxx[xyz]
00:00:48.581 Database = MSP11xxxx
00:00:48.582 Adding new connection
00:00:48.583 Username = abc[adm_sys]
00:00:48.583 Database = xxxxject_xxxx
00:00:48.583 Adding new connection
00:00:48.584 Username = abc[xyz]
00:00:48.584 Database = xxxxject_qua2
00:00:48.585 Adding new connection
00:00:48.585 Username = xxx[xyz]
00:00:48.585 Database = xxxxject_xxxx2
00:00:48.586 Adding new connection
00:00:48.586 Username = xxx[xyz]
00:00:48.586 Database = xxxxject_TST2
00:00:48.587 Adding new connection
00:00:48.587 Username = abc[xyz]
00:00:48.588 Database = xxxxject_qua
00:00:48.588 Adding new connection
00:00:48.589 Username = abc[xyz]
00:00:48.589 Database = xxxxject_tst
00:00:48.590 Adding new connection
00:00:48.590 Username = abc[xyz]
00:00:48.590 Database = xxxxject_EDU2
00:00:48.591 Adding new connection
00:00:48.591 Username = abc[xyz]
00:00:48.592 Database = xxxxject_12c
00:00:48.592 Adding new connection
00:00:48.593 Username = abc
00:00:48.593 Database = xxxxject_xxxx
00:00:48.594 Adding new connection
00:00:48.594 Username = abc
00:00:48.594 Database = xxxxject_xxxx
00:00:48.595 Adding new connection
00:00:48.595 Username = abc
00:00:48.596 Database = xxxxject_12c
00:00:48.597 Adding new connection
00:00:48.597 Username = abc
00:00:48.597 Database = xxxxject_RBEI
00:00:48.598 Adding new connection
00:00:48.598 Username = abc[xyz]
00:00:48.599 Database = xxxxject_xxxx2
00:00:48.600 Adding new connection
00:00:48.600 Username = abc[xyz]
00:00:48.600 Database = xxxxject_RBEI
00:00:48.601 Adding new connection
00:00:48.602 Username = abc[xyz]
00:00:48.602 Database = xxxxject_CIS
00:00:48.603 Adding new connection
00:00:48.603 Username = xxx[xyz]
00:00:48.604 Database = xxxxject_EDU2
00:00:48.605 Adding new connection
00:00:48.605 Username = abc[xyz]
00:00:48.605 Database = xxxxject_perf
00:00:48.606 Adding new connection
00:00:48.607 Username = abc[xyz]
00:00:48.607 Database = xxxxject_MIG2
00:00:48.608 Adding new connection
00:00:48.608 Username = abc[xyz]
00:00:48.609 Database = xxxxject_tst2
00:00:48.610 Adding new connection
00:00:48.610 Username = abc[prx_sys]
00:00:48.611 Database = xxxxject_xxxx
00:00:48.612 Adding new connection
00:00:48.612 Username = abc[xyz]
00:00:48.612 Database = xxxxject_ITF
00:00:48.614 Adding new connection
00:00:48.615 Username = aag1kor[xyz]
00:00:48.615 Database = xxxxject_xxxx
00:00:48.616 Adding new connection
00:00:48.616 Username = aag1kor[xyz]
00:00:48.617 Database = xxxxject_xxxx
00:00:48.638 FindPassword starts for abc[xyz]@xxxxject_xxxx
00:00:48.638 Check current connections...
00:00:48.638 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.639 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.639 Checking abc[xyz]@MSP11QUA...
00:00:48.639 Checking abc[xyz]@msp11xxxx...
00:00:48.640 Checking xxx[xyz]@MSP11xxxx...
00:00:48.640 Checking xxx[xyz]@MSP11xxxx...
00:00:48.640 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.640 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.641 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.641 Checking abc[xyz]@xxxxject_qua2...
00:00:48.641 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.641 Checking xxx[xyz]@xxxxject_TST2...
00:00:48.642 Checking abc[xyz]@xxxxject_qua...
00:00:48.642 Checking abc[xyz]@xxxxject_tst...
00:00:48.642 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.643 Checking abc[xyz]@xxxxject_12c...
00:00:48.643 Checking abc@xxxxject_xxxx...
00:00:48.643 Checking abc@xxxxject_xxxx...
00:00:48.643 Checking abc@xxxxject_12c...
00:00:48.644 Checking abc@xxxxject_RBEI...
00:00:48.644 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.644 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.645 Checking abc[xyz]@xxxxject_CIS...
00:00:48.645 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.646 Checking abc[xyz]@xxxxject_perf...
00:00:48.646 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.646 Checking abc[xyz]@xxxxject_tst2...
00:00:48.647 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.647 Checking abc[xyz]@xxxxject_ITF...
00:00:48.647 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.648 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.648 Check connection definitions...
00:00:48.648 FindPassword ends for abc[xyz]@xxxxject_xxxx, no result
00:00:48.649 FindPassword starts for abc[xyz]@MSP11QUA
00:00:48.649 Check current connections...
00:00:48.649 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.650 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.650 Checking abc[xyz]@MSP11QUA...
00:00:48.650 Checking abc[xyz]@msp11xxxx...
00:00:48.650 Checking xxx[xyz]@MSP11xxxx...
00:00:48.651 Checking xxx[xyz]@MSP11xxxx...
00:00:48.651 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.651 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.652 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.652 Checking abc[xyz]@xxxxject_qua2...
00:00:48.652 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.652 Checking xxx[xyz]@xxxxject_TST2...
00:00:48.653 Checking abc[xyz]@xxxxject_qua...
00:00:48.653 Checking abc[xyz]@xxxxject_tst...
00:00:48.653 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.653 Checking abc[xyz]@xxxxject_12c...
00:00:48.654 Checking abc@xxxxject_xxxx...
00:00:48.654 Checking abc@xxxxject_xxxx...
00:00:48.654 Checking abc@xxxxject_12c...
00:00:48.655 Checking abc@xxxxject_RBEI...
00:00:48.655 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.655 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.655 Checking abc[xyz]@xxxxject_CIS...
00:00:48.656 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.656 Checking abc[xyz]@xxxxject_perf...
00:00:48.656 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.657 Checking abc[xyz]@xxxxject_tst2...
00:00:48.657 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.657 Checking abc[xyz]@xxxxject_ITF...
00:00:48.657 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.658 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.658 Check connection definitions...
00:00:48.658 FindPassword ends for abc[xyz]@MSP11QUA, no result
00:00:48.659 FindPassword starts for abc[xyz]@msp11xxxx
00:00:48.659 Check current connections...
00:00:48.659 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.659 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.660 Checking abc[xyz]@MSP11QUA...
00:00:48.660 Checking abc[xyz]@msp11xxxx...
00:00:48.660 Checking xxx[xyz]@MSP11xxxx...
00:00:48.661 Checking xxx[xyz]@MSP11xxxx...
00:00:48.661 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.661 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.662 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.662 Checking abc[xyz]@xxxxject_qua2...
00:00:48.662 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.663 Checking xxx[xyz]@xxxxject_TST2...
00:00:48.663 Checking abc[xyz]@xxxxject_qua...
00:00:48.663 Checking abc[xyz]@xxxxject_tst...
00:00:48.664 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.664 Checking abc[xyz]@xxxxject_12c...
00:00:48.664 Checking abc@xxxxject_xxxx...
00:00:48.665 Checking abc@xxxxject_xxxx...
00:00:48.665 Checking abc@xxxxject_12c...
00:00:48.665 Checking abc@xxxxject_RBEI...
00:00:48.665 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.666 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.666 Checking abc[xyz]@xxxxject_CIS...
00:00:48.666 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.666 Checking abc[xyz]@xxxxject_perf...
00:00:48.667 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.667 Checking abc[xyz]@xxxxject_tst2...
00:00:48.667 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.668 Checking abc[xyz]@xxxxject_ITF...
00:00:48.668 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.668 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.668 Check connection definitions...
00:00:48.669 FindPassword ends for abc[xyz]@msp11xxxx, no result
00:00:48.669 FindPassword starts for xxx[xyz]@MSP11xxxx
00:00:48.669 Check current connections...
00:00:48.670 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.670 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.670 Checking abc[xyz]@MSP11QUA...
00:00:48.670 Checking abc[xyz]@msp11xxxx...
00:00:48.671 Checking xxx[xyz]@MSP11xxxx...
00:00:48.671 Checking xxx[xyz]@MSP11xxxx...
00:00:48.671 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.671 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.672 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.672 Checking abc[xyz]@xxxxject_qua2...
00:00:48.672 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.673 Checking xxx[xyz]@xxxxject_TST2...
00:00:48.673 Checking abc[xyz]@xxxxject_qua...
00:00:48.673 Checking abc[xyz]@xxxxject_tst...
00:00:48.673 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.674 Checking abc[xyz]@xxxxject_12c...
00:00:48.674 Checking abc@xxxxject_xxxx...
00:00:48.674 Checking abc@xxxxject_xxxx...
00:00:48.674 Checking abc@xxxxject_12c...
00:00:48.675 Checking abc@xxxxject_RBEI...
00:00:48.675 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.675 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.675 Checking abc[xyz]@xxxxject_CIS...
00:00:48.676 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.676 Checking abc[xyz]@xxxxject_perf...
00:00:48.677 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.677 Checking abc[xyz]@xxxxject_tst2...
00:00:48.677 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.678 Checking abc[xyz]@xxxxject_ITF...
00:00:48.678 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.678 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.679 Check connection definitions...
00:00:48.679 FindPassword ends for xxx[xyz]@MSP11xxxx, no result
00:00:48.679 FindPassword starts for xxx[xyz]@MSP11xxxx
00:00:48.679 Check current connections...
00:00:48.680 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.680 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.680 Checking abc[xyz]@MSP11QUA...
00:00:48.681 Checking abc[xyz]@msp11xxxx...
00:00:48.681 Checking xxx[xyz]@MSP11xxxx...
00:00:48.681 Checking xxx[xyz]@MSP11xxxx...
00:00:48.681 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.682 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.682 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.682 Checking abc[xyz]@xxxxject_qua2...
00:00:48.683 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.683 Checking xxx[xyz]@xxxxject_TST2...
00:00:48.683 Checking abc[xyz]@xxxxject_qua...
00:00:48.683 Checking abc[xyz]@xxxxject_tst...
00:00:48.684 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.684 Checking abc[xyz]@xxxxject_12c...
00:00:48.684 Checking abc@xxxxject_xxxx...
00:00:48.685 Checking abc@xxxxject_xxxx...
00:00:48.685 Checking abc@xxxxject_12c...
00:00:48.685 Checking abc@xxxxject_RBEI...
00:00:48.685 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.686 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.686 Checking abc[xyz]@xxxxject_CIS...
00:00:48.686 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.686 Checking abc[xyz]@xxxxject_perf...
00:00:48.687 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.687 Checking abc[xyz]@xxxxject_tst2...
00:00:48.687 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.688 Checking abc[xyz]@xxxxject_ITF...
00:00:48.688 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.688 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.688 Check connection definitions...
00:00:48.689 FindPassword ends for xxx[xyz]@MSP11xxxx, no result
00:00:48.689 FindPassword starts for abc[xyz]@xxxxject_xxxx
00:00:48.689 Check current connections...
00:00:48.689 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.690 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.690 Checking abc[xyz]@MSP11QUA...
00:00:48.690 Checking abc[xyz]@msp11xxxx...
00:00:48.691 Checking xxx[xyz]@MSP11xxxx...
00:00:48.691 Checking xxx[xyz]@MSP11xxxx...
00:00:48.691 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.692 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.692 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.692 Checking abc[xyz]@xxxxject_qua2...
00:00:48.693 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.693 Checking xxx[xyz]@xxxxject_TST2...
00:00:48.693 Checking abc[xyz]@xxxxject_qua...
00:00:48.694 Checking abc[xyz]@xxxxject_tst...
00:00:48.694 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.695 Checking abc[xyz]@xxxxject_12c...
00:00:48.695 Checking abc@xxxxject_xxxx...
00:00:48.695 Checking abc@xxxxject_xxxx...
00:00:48.696 Checking abc@xxxxject_12c...
00:00:48.696 Checking abc@xxxxject_RBEI...
00:00:48.696 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.697 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.697 Checking abc[xyz]@xxxxject_CIS...
00:00:48.697 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.698 Checking abc[xyz]@xxxxject_perf...
00:00:48.698 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.698 Checking abc[xyz]@xxxxject_tst2...
00:00:48.698 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.699 Checking abc[xyz]@xxxxject_ITF...
00:00:48.699 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.699 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.700 Check connection definitions...
00:00:48.700 FindPassword ends for abc[xyz]@xxxxject_xxxx, no result
00:00:48.700 FindPassword starts for xxx[xyz]@MSP11xxxx
00:00:48.700 Check current connections...
00:00:48.701 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.701 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.701 Checking abc[xyz]@MSP11QUA...
00:00:48.701 Checking abc[xyz]@msp11xxxx...
00:00:48.702 Checking xxx[xyz]@MSP11xxxx...
00:00:48.702 Checking xxx[xyz]@MSP11xxxx...
00:00:48.702 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.703 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.703 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.703 Checking abc[xyz]@xxxxject_qua2...
00:00:48.703 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.704 Checking xxx[xyz]@xxxxject_TST2...
00:00:48.704 Checking abc[xyz]@xxxxject_qua...
00:00:48.704 Checking abc[xyz]@xxxxject_tst...
00:00:48.704 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.705 Checking abc[xyz]@xxxxject_12c...
00:00:48.705 Checking abc@xxxxject_xxxx...
00:00:48.705 Checking abc@xxxxject_xxxx...
00:00:48.706 Checking abc@xxxxject_12c...
00:00:48.706 Checking abc@xxxxject_RBEI...
00:00:48.706 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.706 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.707 Checking abc[xyz]@xxxxject_CIS...
00:00:48.707 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.707 Checking abc[xyz]@xxxxject_perf...
00:00:48.707 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.708 Checking abc[xyz]@xxxxject_tst2...
00:00:48.708 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.708 Checking abc[xyz]@xxxxject_ITF...
00:00:48.709 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.709 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.709 Check connection definitions...
00:00:48.709 FindPassword ends for xxx[xyz]@MSP11xxxx , no result
00:00:48.710 FindPassword starts for abc[adm_sys]@xxxxject_xxxx
00:00:48.710 Check current connections...
00:00:48.710 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.710 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.711 Checking abc[xyz]@MSP11QUA...
00:00:48.711 Checking abc[xyz]@msp11xxxx...
00:00:48.711 Checking xxx[xyz]@MSP11xxxx...
00:00:48.712 Checking xxx[xyz]@MSP11xxxx...
00:00:48.712 Checking abc[xyz]@xxxxject_xxxx...
00:00:48.712 Checking xxx[xyz]@MSP11xxxx ...
00:00:48.713 Checking abc[adm_sys]@xxxxject_xxxx...
00:00:48.713 Checking abc[xyz]@xxxxject_...
00:00:48.713 Checking xxx[xyz]@xxxxject_xxxx2...
00:00:48.713 Checking xxx[xyz]@xxxxject_...
00:00:48.714 Checking abc[xyz]@xxxxject_qua...
00:00:48.714 Checking abc[xyz]@xxxxject_tst...
00:00:48.714 Checking abc[xyz]@xxxxject_EDU2...
00:00:48.715 Checking abc[xyz]@xxxxject_12c...
00:00:48.715 Checking abc@xxxxject_xxxx...
00:00:48.715 Checking abc@xxxxject_xxxx...
00:00:48.715 Checking abc@xxxxject_12c...
00:00:48.716 Checking abc@xxxxject_RBEI...
00:00:48.716 Checking abc[xyz]@xxxxject_xxxx2...
00:00:48.716 Checking abc[xyz]@xxxxject_RBEI...
00:00:48.716 Checking abc[xyz]@xxxxject_CIS...
00:00:48.717 Checking xxx[xyz]@xxxxject_EDU2...
00:00:48.717 Checking abc[xyz]@xxxxject_perf...
00:00:48.717 Checking abc[xyz]@xxxxject_MIG2...
00:00:48.718 Checking abc[xyz]@xxxxject_tst2...
00:00:48.718 Checking abc[prx_sys]@xxxxject_xxxx...
00:00:48.718 Checking abc[xyz]@xxxxject_ITF...
00:00:48.718 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.719 Checking aag1kor[xyz]@xxxxject_xxxx...
00:00:48.719 Check connection definitions...
0

 

[Marco Kalter]

Logging on takes 10 seconds, which is of course much too long. Can you go to Help > Support Info and copy the information from the "Info" tab page?

 

[Shivu]

PL/SQL Developer
Version 11.0.2.1766
81.101382 - 100 user license
Service Contract: 01.06.2016
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.194.304 kB (4.194.304 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.881.144 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe

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

Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\GRH5KOR\AppData\Roaming\PLSQL Developer\Preferences\GRH5kor\default.ini

License File
C:\Program Files (x86)\PLSQL Developer\aalf.dat

Debug file
C:\Program Files (x86)\PLSQL Developer\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
(ADDRESS
(ADDRESS_LIST
(CONNECT_DATA
(DESCRIPTION
(ORACLE_SID
...

Homes
oracleas1 (C:\OraHome_1)
OraClient11g_home1 (C:\Oracle\Cli11gR2_32\)

DLLs
C:\Oracle\Cli11gR2_32\bin\oci.dll

TNS File
C:\oracle\ora_net\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\Oracle\Cli11gR2_32\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.4.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

Monitor
Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1200

MainFormOnTaskbar = False