Very slow closing all windows - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Very slow closing all windows

Print Thread

Very slow closing all windows #61671 05/20/20 12:31 PM
Joined: Mar 2005 Posts: 26 Italy R RamosIt OP Member
OP RamosIt Member R Joined: Mar 2005 Posts: 26 Italy	Hi. it's a lot of time a face a frustrating problem. I had it using version 12, then 13 and also now using version 14. It takes a lot of time to close each and every window type (sql windows, program windows, test windows etc.) I have to wait also 7-10 seconds per window. I recorded this problems, please refer to following link: https://youtu.be/mjSebdOOMgc (58 seconds of video, 2MB ) I also recorded debug information for all was happening during action explained in video recording. At the end of this Post the content of Debug.txt i had activated. Can you please help me? it's a very frustrating situation! Thank you in advance -----START-DEBUG.TXT------ PL/SQL Developer Version 14.0.0.1961 (32 bit) Windows 10 (64-bit) Build 18362 Physical memory : 8.317.080 kB (1.889.212 available) Paging file : 12.380.312 kB (2.694.532 available) Virtual memory : 2.097.024 kB (1.841.828 available) Parameters C:\Program Files (x86)\PLSQL Developer 14\plsqldev.exe DebugSQL Preferences Session mode: Multi OCI Library: <none> Use OCI7: False Allow Multiple Connections: True Preference Files Debug file C:\Users\omars\AppData\Roaming\PLSQL Developer 14\PlSqlDev.elf Plug-Ins Process Working Set = 76.726.272 Memory = 23.098.208 GDI Objects = 561 User Objects = 318 Handles = 391 Monitor PixelsPerInch = 96 Id = 0 PPI = 96 Primary = True Handle = 65537 Left = 0 Top = 0 Width = 1920 Height = 1080 MainFormOnTaskbar = True 20/05/2020 14:18:33 Debug started 00:00:00.010 InitPreferences 00:00:00.012 Load C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences\default = 0 00:00:00.013 PreferenceSet.Load C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences\default\Default.ini 00:00:00.015 PreferenceSet.Load OK 00:00:00.017 Determine LocalPrefPath 00:00:00.018 [1]: C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences 00:00:00.019 LocalPrefPath: C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences\omars 00:00:00.020 Load C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences\omars = 0 00:00:00.021 PreferenceSet.Load C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences\omars\default.ini 00:00:00.023 PreferenceSet.Load OK 00:00:00.024 PreferenceSet.Load C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences\omars\user.prefs 00:00:00.028 PreferenceSet.Load OK 00:00:00.029 InitPreferences end 00:00:00.031 SortPreferenceSets 00:00:00.032 - Default omars 00:00:00.033 - System Default 00:00:00.599 UpdateConnections (True) 00:00:00.600 UpdateConnections: Connections = 0, Folders = 0, Start Nodes = 0 00:00:00.601 UpdateConnections: Clear 00:00:00.602 UpdateConnections: Add Items (0) 00:00:00.603 UpdateConnections: Recent Folder 00:00:00.606 UpdateConnections: Folder Filters 00:00:00.608 UpdateConnections: Create NodeList 00:00:00.609 UpdateConnections: Check NodeList 00:00:00.611 UpdateConnections: Free NodeList 00:00:00.612 UpdateConnectionsChildList start 00:00:00.615 UpdateConnectionsChildList ConnectionFolders.Count = 1 00:00:00.617 UpdateConnectionsChildList CheckList.Count = 1 00:00:00.618 UpdateConnectionsChildList RemoveList.Count = 0 00:00:00.619 UpdateConnectionsChildList EndUpdate 00:00:00.620 UpdateConnectionsChildList end 00:00:00.621 UpdateConnections: Reopen Folders 00:00:00.623 UpdateConnections: Sort 00:00:00.627 UpdateConnections: Final Nodes = 1 00:00:00.628 UpdateConnections Done 00:00:00.629 DoUpdateChildList starts 00:00:00.673 Lock 00:00:00.675 UnLock 00:00:00.677 00:00:00.678 20/05/2020 14:18:34 Debug stopped 00:00:00.679 00:00:00.688 pfReadRegistry(PL/SQL Developer 14\Shell\Open\Command, ) 00:00:00.690 ReadString Faled 00:00:00.691 pfReadRegistry: 00:00:00.692 CalculateToolbarGlyphs (DPI = 96) 00:00:01.178 CalculateToolbarGlyphs done 00:00:01.983 Splash: Starting PL/SQL Developer 14 00:00:02.029 Splash: Version 14.0.0.1961 (32 bit) 00:00:02.072 LoadPreferences 00:00:02.074 LoadPreferences searching for default 00:00:02.075 C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Preferences\omars\default.ini 00:00:02.076 LoadPreferences NewPref := nil 00:00:02.077 LoadPreferences <section 2> 00:00:02.079 LoadPreferences Reading preferences 00:00:02.104 Splash: Reading preferences 00:00:02.105 LoadPreferences ToolsBrowserItemClick(nil) 00:00:02.139 LoadPreferences CreateBrowserFilters... 00:00:02.143 LoadPreferences Files 00:00:02.144 LoadPreferences Printer 00:00:02.145 LoadPreferences FileBrowserFolders 00:00:02.147 LoadPreferences Connections 00:00:02.150 LoadPreferences BrowserFolders 00:00:02.152 LoadPreferences <section 3> 00:00:02.153 LoadPreferences end 00:00:02.516 MacroLibFilename: C:\Program Files (x86)\PLSQL Developer 14\Macro\omars.emlib 00:00:02.607 Splash: Reading keywords 00:00:02.613 GetRootFile: C:\Users\omars\AppData\Roaming\PLSQL Developer 14\default.kwf 00:00:02.651 Logging on.. 00:00:02.653 Creating new session 00:00:02.654 Initializing new session 00:00:02.655 Setting new session parameters 00:00:02.663 Setting logon session 00:00:02.667 UpdateConnections (True) 00:00:02.672 UpdateConnections: Connections = 80, Folders = 73, Start Nodes = 1 00:00:02.677 UpdateConnections: Clear 00:00:02.683 UpdateConnections: Add Items (73) 00:00:02.721 UpdateConnections: Recent Folder 00:00:02.725 UpdateConnections: Folder Filters 00:00:02.726 UpdateConnections: Create NodeList 00:00:02.734 UpdateConnections: Check NodeList 00:00:02.756 UpdateConnections: Free NodeList 00:00:02.757 UpdateConnectionsChildList start 00:00:02.770 UpdateConnectionsChildList ConnectionFolders.Count = 154 00:00:02.771 UpdateConnectionsChildList CheckList.Count = 154 00:00:02.784 UpdateConnectionsChildList RemoveList.Count = 0 00:00:02.785 UpdateConnectionsChildList EndUpdate 00:00:02.786 UpdateConnectionsChildList end 00:00:02.787 UpdateConnections: Reopen Folders 00:00:03.005 UpdateConnections: Sort 00:00:03.174 UpdateConnections: Final Nodes = 154 00:00:03.175 UpdateConnections Done 00:00:03.183 DoConnectionLogon starts 00:00:03.243 ConnectionLogonForm created 00:00:03.480 Connections loaded (154) 00:00:03.529 ConnectionLogonForm Show modal 00:00:06.544 TOracleSession $09D01D10 Start Session.LogOn as omar@UFFICIO_MESTRE_PUBLIC 00:00:07.910 TOracleQuery Query Start Query.Execute SQL = select to_char(userenv('SESSIONID')) from dual 00:00:08.043 TOracleQuery Query End (1 record processed) Duration = 0,125 00:00:08.044 TOracleSession $09D01D10 End Duration = 1,5 00:00:08.096 DoConnectionLogon ends 00:00:08.097 OCI Initialization starts 00:00:08.098 OCI Initialization done 00:00:08.100 OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient12Home1_32bit OracleHomeDir: C:\app\omars\product\12.2.0\client_1 Found: oci.dll Using: C:\app\omars\product\12.2.0\client_1\bin\oci.dll 00:00:08.124 TOracleQuery $080AA380 Start Query.Execute SQL = select sys_context('userenv', 'current_schema') from dual 00:00:08.275 TOracleQuery $080AA380 End (1 record processed) Duration = 0,156 00:00:08.278 TOracleSession $09D01FF0 Start Session.LogOn as omar@UFFICIO_MESTRE_PUBLIC 00:00:09.001 TOracleQuery Query Start Query.Execute SQL = select to_char(userenv('SESSIONID')) from dual 00:00:09.154 TOracleQuery Query End (1 record processed) Duration = 0,156 00:00:09.155 TOracleSession $09D01FF0 End Duration = 0,875 00:00:09.162 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:09.163 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:09.304 TOracleQuery BytesPerCharacterQuery End (1 record processed) Duration = 0,14 00:00:09.305 TOracleQuery BytesPerCharacterQuery Start Query.Execute SQL = select lengthb(nchr(20)), nchr(20) from dual 00:00:09.342 TOracleQuery BytesPerCharacterQuery End (1 record processed) Duration = 0,171 00:00:09.343 TOracleQuery BytesPerCharacterQuery Start Query.Execute SQL = select lengthb(nchr(20)), nchr(20) from dual 00:00:09.455 TOracleQuery BytesPerCharacterQuery End (1 record processed) Duration = 0,141 00:00:09.456 TOracleQuery $080AA640 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 Developer installation directory for all users, or in the "%APPDATA%\PLSQL Developer" 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', 'PROCEDURE', 'FUNCTION', 'SEQUENCE') :SCHEMA = OMAR 00:00:09.502 TOracleQuery BytesPerCharacterQuery End (1 record processed) Duration = 0,157 00:00:09.503 TOracleQuery $080A9E00 Start Query.Execute SQL = begin :n := user; end; :N = Null 00:00:09.608 TOracleQuery $080A9E00 End Duration = 0,094 00:00:09.612 TOracleQuery Query Start Query.Execute SQL = select from v$version 00:00:09.683 TOracleQuery $080AA640 End (28 records processed) Duration = 0,219 00:00:09.685 TOracleQuery $080AA640 Start Query.Execute SQL = select s.synonym_name as object_name, o.object_type from sys.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', 'PROCEDURE', 'FUNCTION', 'SEQUENCE') :SCHEMA = OMAR 00:00:09.747 TOracleQuery Query End (5 records processed) Duration = 0,125 00:00:09.751 LogonHistorySave start 00:00:09.753 ChangeUserPref LogonHistory, 00:00:09.755 ChangeUserPref DSA, 00:00:09.757 ChangeUserPref end 00:00:09.759 ChangeUserPref ColumnAssociations, 00:00:09.761 ChangeUserPref end 00:00:09.762 ChangeUserPref ImportAssociations, 00:00:09.765 ChangeUserPref end 00:00:09.766 ChangeUserPref BrowserFilters, 00:00:09.768 ChangeUserPref end 00:00:09.769 ChangeUserPref FileBrowserFolders, 00:00:09.771 ChangeUserPref end 00:00:09.772 ChangeUserPref Connections, 00:00:09.776 ChangeUserPref end 00:00:09.777 ChangeUserPref BrowserFolders, 00:00:09.779 ChangeUserPref end 00:00:09.780 ChangeUserPref SessionQueries, 00:00:09.781 ChangeUserPref end 00:00:09.782 ChangeUserPref ExternalTools, 00:00:09.783 ChangeUserPref end 00:00:09.784 ChangeUserPref Documents, 00:00:09.786 ChangeUserPref end 00:00:09.787 ChangeUserPref WebSearches, 00:00:09.788 ChangeUserPref end 00:00:09.789 ChangeUserPref Reports, 00:00:09.790 ChangeUserPref end 00:00:09.791 ChangeUserPref CurrentConnections, 00:00:09.792 ChangeUserPref end 00:00:09.793 LogonHistorySave end 00:00:09.814 Splash: connected 00:00:09.817 FormCreate Logon.Executed -1 00:00:09.853 FormCreate SessionChanged 00:00:09.855 TOracleQuery $09A73580 Start Query.Execute SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID') 00:00:09.988 TOracleQuery $080AA640 End (100 records processed) Duration = 0,297 00:00:09.990 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:09.992 TOracleQuery $09A73580 End (1 record processed) Duration = 0,141 00:00:09.993 SessionChanged SetDBAViews 00:00:09.994 TOracleQuery $09A73580 Start Query.Execute SQL = select null from all_synonyms where 1=0 00:00:10.056 TOracleQuery $080AA640 End (100 records processed) Duration = 0,062 00:00:10.058 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.127 TOracleQuery $080AA640 End (100 records processed) Duration = 0,063 00:00:10.129 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.130 TOracleQuery $09A73580 End (0 records processed) Duration = 0,125 00:00:10.131 TOracleQuery $09A73580 Start Query.Execute SQL = select null from dba_synonyms where 1=0 00:00:10.211 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:10.212 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.293 TOracleQuery $080AA640 End (100 records processed) Duration = 0,079 00:00:10.295 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.346 TOracleQuery $09A73580 End (0 records processed) Duration = 0,203 00:00:10.348 SessionChanged Authorizations.Load 00:00:10.349 SessionChanged EnableAuthorizedMenus 00:00:10.350 WindowAllowed(1) 00:00:10.351 WindowAllowed done 00:00:10.352 WindowAllowed(1) 00:00:10.353 WindowAllowed done 00:00:10.354 ExecuteConnectScript starts 00:00:10.356 GetRootFile: C:\Users\omars\AppData\Roaming\PLSQL Developer 14\AfterConnect.sql 00:00:10.357 TOracleQuery $09A73580 Start Query.Execute SQL = select sys_context('userenv', 'current_schema') from dual 00:00:10.389 TOracleQuery $080AA640 End (100 records processed) Duration = 0,093 00:00:10.391 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.470 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:10.472 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.503 TOracleQuery $09A73580 End (1 record processed) Duration = 0,141 00:00:10.505 TOracleQuery $09A73580 Start Query.Execute SQL = alter session set plsql_optimize_level = 2 00:00:10.554 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:10.557 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.582 TOracleQuery $09A73580 End Duration = 0,063 00:00:10.583 TOracleQuery $09A73580 Start Query.Execute SQL = alter session set plsql_code_type = interpreted 00:00:10.638 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:10.640 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.659 TOracleQuery $09A73580 End Duration = 0,063 00:00:10.661 ExecuteConnectScript ends 00:00:10.713 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:10.717 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.785 TOracleQuery $080AA640 End (100 records processed) Duration = 0,079 00:00:10.788 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.824 SetSessionAction starts: Primary Session 00:00:10.825 TOracleQuery $09A73580 Start Query.Execute SQL = select null from dual 00:00:10.864 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:10.866 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.942 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:10.944 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:10.962 TOracleQuery $09A73580 End (1 record processed) Duration = 0,14 00:00:10.964 TOracleQuery $09A73580 Start Query.Execute SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end; :ACTION = Primary Session 00:00:11.015 TOracleQuery $080AA640 End (100 records processed) Duration = 0,062 00:00:11.016 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:11.047 TOracleQuery $09A73580 End Duration = 0,079 00:00:11.048 SetSessionAction ends 00:00:11.090 SessionChanged LoadRecentObjects 00:00:11.093 SessionChanged Logoff secondary sessions 00:00:11.094 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:11.095 SessionChanged OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient12Home1_32bit OracleHomeDir: C:\app\omars\product\12.2.0\client_1 Found: oci.dll Using: C:\app\omars\product\12.2.0\client_1\bin\oci.dll 00:00:11.096 SessionChanged Notify children 00:00:11.097 SessionChanged EnableChildFunctions 00:00:11.098 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:11.174 Lock 00:00:11.175 UnLock 00:00:11.178 TOracleQuery $080AA640 End (100 records processed) Duration = 0,063 00:00:11.180 Lock 00:00:11.182 UnLock 00:00:11.183 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:11.184 UpdateChildList starts 00:00:11.255 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:11.257 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:11.335 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:11.338 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:11.415 TOracleQuery $080AA640 End (100 records processed) Duration = 0,079 00:00:11.417 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:11.997 TOracleQuery $080AA640 End (100 records processed) Duration = 0,578 00:00:12.000 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.076 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:12.079 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.208 TOracleQuery $080AA640 End (100 records processed) Duration = 0,14 00:00:12.213 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.292 TOracleQuery $080AA640 End (100 records processed) Duration = 0,079 00:00:12.296 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.364 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:12.366 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.381 Splash: . 00:00:12.451 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:12.453 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.534 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:12.539 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.610 TOracleQuery $080AA640 End (100 records processed) Duration = 0,062 00:00:12.612 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.688 TOracleQuery $080AA640 End (100 records processed) Duration = 0,062 00:00:12.690 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.770 TOracleQuery $080AA640 End (100 records processed) Duration = 0,062 00:00:12.772 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.845 TOracleQuery $080AA640 End (100 records processed) Duration = 0,062 00:00:12.847 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:12.926 TOracleQuery $080AA640 End (100 records processed) Duration = 0,079 00:00:12.928 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.006 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:13.008 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.099 TOracleQuery $080AA640 End (100 records processed) Duration = 0,094 00:00:13.102 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.182 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:13.185 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.275 TOracleQuery $080AA640 End (100 records processed) Duration = 0,094 00:00:13.277 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.285 SortPreferenceSets 00:00:13.287 - Default omars 00:00:13.289 - System Default 00:00:13.362 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:13.366 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.386 ReadTemplateFiles C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Template 00:00:13.446 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:13.448 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.541 TOracleQuery $080AA640 End (100 records processed) Duration = 0,094 00:00:13.543 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.626 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:13.630 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.713 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:13.716 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.801 TOracleQuery $080AA640 End (100 records processed) Duration = 0,094 00:00:13.805 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.817 ReadTemplateFiles Done 00:00:13.896 TOracleQuery $080AA640 End (100 records processed) Duration = 0,094 00:00:13.901 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:13.993 TOracleQuery $080AA640 End (100 records processed) Duration = 0,094 00:00:13.996 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.110 TOracleQuery $080AA640 End (100 records processed) Duration = 0,109 00:00:14.116 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.196 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:14.199 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.221 TOracleQuery $09A73580 Start Query.Execute SQL = select null from all_synonyms where 1=0 00:00:14.282 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:14.284 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.349 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:14.351 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.355 TOracleQuery $09A73580 End (0 records processed) Duration = 0,141 00:00:14.356 TOracleQuery $09A73580 Start Query.Execute SQL = select null from dba_synonyms where 1=0 00:00:14.425 TOracleQuery $080AA640 End (100 records processed) Duration = 0,063 00:00:14.427 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.472 TOracleQuery $09A73580 End (0 records processed) Duration = 0,109 00:00:14.475 Lock 00:00:14.476 UnLock 00:00:14.482 UpdateConnections (True) 00:00:14.484 UpdateConnections: Connections = 80, Folders = 73, Start Nodes = 0 00:00:14.496 UpdateConnections: Clear 00:00:14.497 UpdateConnections: Add Items (73) 00:00:14.539 UpdateConnections: Recent Folder 00:00:14.540 UpdateConnections: Folder Filters 00:00:14.542 UpdateConnections: Create NodeList 00:00:14.547 UpdateConnections: Check NodeList 00:00:14.566 UpdateConnections: Free NodeList 00:00:14.567 UpdateConnectionsChildList start 00:00:14.578 UpdateConnectionsChildList ConnectionFolders.Count = 154 00:00:14.579 UpdateConnectionsChildList CheckList.Count = 154 00:00:14.584 TOracleQuery $080AA640 End (100 records processed) Duration = 0,156 00:00:14.589 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.598 UpdateConnectionsChildList RemoveList.Count = 0 00:00:14.600 UpdateConnectionsChildList EndUpdate 00:00:14.603 UpdateConnectionsChildList end 00:00:14.605 UpdateConnections: Reopen Folders 00:00:14.755 TOracleQuery $080AA640 End (100 records processed) Duration = 0,172 00:00:14.757 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.846 TOracleQuery $080AA640 End (100 records processed) Duration = 0,078 00:00:14.848 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:14.877 UpdateConnections: Sort 00:00:15.029 UpdateConnections: Final Nodes = 154 00:00:15.030 UpdateConnections Done 00:00:15.031 DoUpdateChildList starts 00:00:15.034 Lock 00:00:15.035 UnLock 00:00:15.036 00:00:15.037 20/05/2020 14:18:48 Debug stopped 00:00:15.038 00:00:15.065 Splash: Loading Desktop 00:00:15.066 LoadDesktop starts 00:00:15.122 LoadDesktop DoUpdateChildList starts 00:00:15.124 DoUpdateChildList starts 00:00:15.125 LoadDesktop DoUpdateChildList ends 00:00:15.126 LoadDesktop ends 00:00:15.129 Splash: Finished 00:00:15.133 FormActivate start 00:00:15.204 TOracleQuery $080AA640 End (100 records processed) Duration = 0,344 00:00:15.208 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:15.391 TOracleQuery $080AA640 End (100 records processed) Duration = 0,172 00:00:15.393 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:15.447 FormActivate end 00:00:15.493 TOracleQuery $080AA640 End (100 records processed) Duration = 0,11 00:00:15.498 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:15.654 TOracleQuery $080AA640 End (100 records processed) Duration = 0,156 00:00:15.659 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:15.738 TOracleQuery $080AA640 End (100 records processed) Duration = 0,062 00:00:15.746 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:15.873 TOracleQuery $080AA640 End (100 records processed) Duration = 0,125 00:00:15.877 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:15.960 TOracleQuery $080AA640 End (100 records processed) Duration = 0,093 00:00:15.963 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:16.041 TOracleQuery $080AA640 End (100 records processed) Duration = 0,079 00:00:16.043 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:16.158 TOracleQuery $080AA640 End (100 records processed) Duration = 0,109 00:00:16.160 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:16.273 TOracleQuery $080AA640 End (100 records processed) Duration = 0,109 00:00:16.275 TOracleQuery $080AA640 Start Query.Next for up to 100 records 00:00:16.309 FormResize 00:00:16.312 VCS Cache disabled (0) 00:00:16.314 FormShow Ends 00:00:16.493 TOracleQuery $080AA640 End (79 records processed) Duration = 0,219 00:00:16.496 TOracleQuery $080AA640 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 = OMAR 00:00:16.605 FormResize 00:00:16.621 WMUpdatePopups starts 00:00:16.668 TOracleQuery $080AA640 End (1 record processed) Duration = 0,172 00:00:16.673 TOracleSession $09D01FF0 Start Session.LogOff 00:00:16.726 Initialize Clipboard History starts 00:00:16.732 InitClipboardHistory starts 00:00:16.748 TOracleSession $09D01FF0 End Duration = 0,063 00:00:16.753 InitClipboardHistory ends 00:00:16.936 Clipboard size = 100 items, 29840 bytes 00:00:16.937 Initialize Clipboard History done 00:00:17.404 DoUpdateChildList starts 00:00:17.405 DoUpdateChildList Lock 00:00:17.407 Lock 00:00:17.408 UnLock 00:00:17.408 UpdateConnectionsChildList start 00:00:17.421 UpdateConnectionsChildList ConnectionFolders.Count = 154 00:00:17.425 UpdateConnectionsChildList CheckList.Count = 154 00:00:17.444 UpdateConnectionsChildList RemoveList.Count = 0 00:00:17.447 UpdateConnectionsChildList EndUpdate 00:00:17.448 UpdateConnectionsChildList end 00:00:17.449 DoUpdateChildList UnLock 00:00:17.451 DoUpdateChildList ends 00:00:17.502 WMUpdatePopups ends 00:00:20.135 ThreadedDownload for https://www.allroundautomations.com/update/plsall.updates starts 00:00:20.138 ThreadedDownload done 00:00:20.140 WebUpdate.DownloadTextFile: URL=https://www.allroundautomations.com/update/plsall.updates 00:00:20.141 WebUpdate.DownloadTextFile: DST=C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Update 00:00:20.143 WebUpdate.DownloadTextFile: FILE=C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Update\plsall.updates 00:00:20.145 WebUpdate.URLDownload starts 00:00:20.810 WebUpdate.URLDownload ends: True 00:00:20.812 WebUpdate.DownloadTextFile done 00:00:24.476 Create TSQLForm Start 00:00:24.481 Create TSQLForm Inherited 00:00:24.606 TSQLForm.FormCreate Start 00:00:24.615 StartMatches starts 00:00:24.616 StartMatches ends 00:00:24.617 EndMatches starts 00:00:24.618 EndMatches ends 00:00:24.619 SQLForm 00:00:24.684 TSQLForm.FormCreate Finished 00:00:24.740 Create TSQLForm SetupMainFont 00:00:24.751 Create TSQLForm Activate 00:00:24.752 UpdateChildList starts 00:00:24.753 UpdateChildList [timer] 00:00:24.754 UpdateChildList ends 00:00:24.755 Create TSQLForm Activate done 00:00:24.757 Create TSQLForm UpdateWindowList 00:00:24.759 UpdateChildList starts 00:00:24.760 UpdateChildList [timer] 00:00:24.761 UpdateChildList ends 00:00:24.762 Create TSQLForm Positioning 00:00:24.763 Create TSQLForm Finished 00:00:24.764 ExecuteTemplateByName: Default\SQL Window 00:00:24.768 ExecuteTemplate: C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Template\Default\SQL Window.tpl 00:00:24.770 Path: C:\Users\omars\AppData\Roaming\PLSQL Developer 14\Template\Default\SQL Window.tpl 00:00:24.778 Lock 00:00:24.781 UnLock 00:00:24.783 StartMatches starts 00:00:24.784 StartMatches ends 00:00:24.786 EndMatches starts 00:00:24.787 EndMatches ends 00:00:24.798 Lock 00:00:24.799 UnLock 00:00:24.812 Lock 00:00:24.814 UnLock 00:00:24.825 Lock 00:00:24.827 UnLock 00:00:24.828 NavigationBookmarks.EnableButtons(Rebuild) 00:00:24.830 NavigationBookmarks: Backward=0, Forward=0 00:00:24.831 WindowAllowed(3) 00:00:24.834 WindowAllowed done 00:00:24.836 WindowAllowed(2) 00:00:24.837 WindowAllowed done 00:00:24.839 WindowAllowed(6) 00:00:24.840 WindowAllowed done 00:00:24.842 WindowAllowed(4) 00:00:24.843 WindowAllowed done 00:00:24.844 WindowAllowed(5) 00:00:24.845 WindowAllowed done 00:00:24.917 DoUpdateChildList starts 00:00:24.918 DoUpdateChildList Lock 00:00:24.980 Lock 00:00:24.995 UnLock 00:00:24.997 UpdateConnectionsChildList start 00:00:25.010 UpdateConnectionsChildList ConnectionFolders.Count = 154 00:00:25.011 UpdateConnectionsChildList CheckList.Count = 154 00:00:25.025 UpdateConnectionsChildList RemoveList.Count = 0 00:00:25.026 UpdateConnectionsChildList EndUpdate 00:00:25.027 UpdateConnectionsChildList end 00:00:25.029 DoUpdateChildList UnLock 00:00:25.039 DoUpdateChildList ends 00:00:25.869 Lock 00:00:25.871 UnLock 00:00:25.872 StartMatches starts 00:00:25.873 StartMatches ends 00:00:25.874 EndMatches starts 00:00:25.875 EndMatches ends 00:00:25.890 StartMatches starts 00:00:25.892 StartMatches ends 00:00:25.893 EndMatches starts 00:00:25.895 EndMatches ends 00:00:25.994 StartMatches starts 00:00:25.996 StartMatches ends 00:00:25.997 EndMatches starts 00:00:25.998 EndMatches ends 00:00:26.073 StartMatches starts 00:00:26.074 StartMatches ends 00:00:26.075 EndMatches starts 00:00:26.076 EndMatches ends 00:00:26.079 StartMatches starts 00:00:26.080 StartMatches ends 00:00:26.081 EndMatches starts 00:00:26.082 EndMatches ends 00:00:26.137 StartMatches starts 00:00:26.138 StartMatches ends 00:00:26.139 EndMatches starts 00:00:26.140 EndMatches ends 00:00:26.178 StartMatches starts 00:00:26.179 StartMatches ends 00:00:26.182 EndMatches starts 00:00:26.183 EndMatches ends 00:00:26.188 StartMatches starts 00:00:26.190 StartMatches ends 00:00:26.191 EndMatches starts 00:00:26.192 EndMatches ends 00:00:26.227 StartMatches starts 00:00:26.228 StartMatches ends 00:00:26.229 EndMatches starts 00:00:26.230 EndMatches ends 00:00:26.232 StartMatches starts 00:00:26.233 StartMatches ends 00:00:26.234 EndMatches starts 00:00:26.235 EndMatches ends 00:00:26.313 StartMatches starts 00:00:26.314 StartMatches ends 00:00:26.315 EndMatches starts 00:00:26.316 EndMatches ends 00:00:26.319 StartMatches starts 00:00:26.320 StartMatches ends 00:00:26.321 EndMatches starts 00:00:26.322 EndMatches ends 00:00:26.393 StartMatches starts 00:00:26.395 StartMatches ends 00:00:26.397 EndMatches starts 00:00:26.398 EndMatches ends 00:00:26.482 StartMatches starts 00:00:26.483 StartMatches ends 00:00:26.485 EndMatches starts 00:00:26.486 EndMatches ends 00:00:26.490 StartMatches starts 00:00:26.491 StartMatches ends 00:00:26.492 EndMatches starts 00:00:26.493 EndMatches ends 00:00:26.569 StartMatches starts 00:00:26.570 StartMatches ends 00:00:26.571 EndMatches starts 00:00:26.572 EndMatches ends 00:00:26.575 StartMatches starts 00:00:26.576 StartMatches ends 00:00:26.577 EndMatches starts 00:00:26.578 EndMatches ends 00:00:26.626 StartMatches starts 00:00:26.627 StartMatches ends 00:00:26.628 EndMatches starts 00:00:26.629 EndMatches ends 00:00:26.777 StartMatches starts 00:00:26.778 StartMatches ends 00:00:26.779 EndMatches starts 00:00:26.780 EndMatches ends 00:00:26.946 StartMatches starts 00:00:26.947 StartMatches ends 00:00:26.949 EndMatches starts 00:00:26.950 EndMatches ends 00:00:26.953 StartMatches starts 00:00:26.954 StartMatches ends 00:00:26.955 EndMatches starts 00:00:26.956 EndMatches ends 00:00:27.049 StartMatches starts 00:00:27.050 StartMatches ends 00:00:27.051 EndMatches starts 00:00:27.052 EndMatches ends 00:00:27.097 StartMatches starts 00:00:27.098 StartMatches ends 00:00:27.099 EndMatches starts 00:00:27.100 EndMatches ends 00:00:27.105 StartMatches starts 00:00:27.106 StartMatches ends 00:00:27.107 EndMatches starts 00:00:27.107 EndMatches ends 00:00:27.169 StartMatches starts 00:00:27.170 StartMatches ends 00:00:27.171 EndMatches starts 00:00:27.172 EndMatches ends 00:00:27.202 StartMatches starts 00:00:27.204 StartMatches ends 00:00:27.205 EndMatches starts 00:00:27.206 EndMatches ends 00:00:27.218 StartMatches starts 00:00:27.219 StartMatches ends 00:00:27.220 EndMatches starts 00:00:27.221 EndMatches ends 00:00:27.273 StartMatches starts 00:00:27.274 StartMatches ends 00:00:27.275 EndMatches starts 00:00:27.277 EndMatches ends 00:00:27.347 StartMatches starts 00:00:27.348 StartMatches ends 00:00:27.349 EndMatches starts 00:00:27.350 EndMatches ends 00:00:27.353 StartMatches starts 00:00:27.354 StartMatches ends 00:00:27.355 EndMatches starts 00:00:27.356 EndMatches ends 00:00:27.409 StartMatches starts 00:00:27.410 StartMatches ends 00:00:27.412 EndMatches starts 00:00:27.413 EndMatches ends 00:00:27.422 StartMatches starts 00:00:27.423 StartMatches ends 00:00:27.424 EndMatches starts 00:00:27.425 EndMatches ends 00:00:27.497 StartMatches starts 00:00:27.498 StartMatches ends 00:00:27.499 EndMatches starts 00:00:27.500 EndMatches ends 00:00:27.545 StartMatches starts 00:00:27.546 StartMatches ends 00:00:27.548 EndMatches starts 00:00:27.550 EndMatches ends 00:00:27.554 StartMatches starts 00:00:27.555 StartMatches ends 00:00:27.556 EndMatches starts 00:00:27.557 EndMatches ends 00:00:27.625 StartMatches starts 00:00:27.626 StartMatches ends 00:00:27.628 EndMatches starts 00:00:27.629 EndMatches ends 00:00:27.632 StartMatches starts 00:00:27.633 StartMatches ends 00:00:27.634 EndMatches starts 00:00:27.635 EndMatches ends 00:00:27.721 StartMatches starts 00:00:27.722 StartMatches ends 00:00:27.723 EndMatches starts 00:00:27.724 EndMatches ends 00:00:27.753 StartMatches starts 00:00:27.754 StartMatches ends 00:00:27.755 EndMatches starts 00:00:27.756 EndMatches ends 00:00:27.759 StartMatches starts 00:00:27.760 StartMatches ends 00:00:27.761 EndMatches starts 00:00:27.762 EndMatches ends 00:00:27.849 StartMatches starts 00:00:27.850 StartMatches ends 00:00:27.851 EndMatches starts 00:00:27.852 EndMatches ends 00:00:27.855 StartMatches starts 00:00:27.856 StartMatches ends 00:00:27.857 EndMatches starts 00:00:27.858 EndMatches ends 00:00:27.937 StartMatches starts 00:00:27.938 StartMatches ends 00:00:27.939 EndMatches starts 00:00:27.940 EndMatches ends 00:00:27.969 StartMatches starts 00:00:27.970 StartMatches ends 00:00:27.971 EndMatches starts 00:00:27.972 EndMatches ends 00:00:27.976 StartMatches starts 00:00:27.977 StartMatches ends 00:00:27.978 EndMatches starts 00:00:27.979 EndMatches ends 00:00:28.065 StartMatches starts 00:00:28.066 StartMatches ends 00:00:28.067 EndMatches starts 00:00:28.068 EndMatches ends 00:00:28.070 StartMatches starts 00:00:28.071 StartMatches ends 00:00:28.073 EndMatches starts 00:00:28.073 EndMatches ends 00:00:28.185 StartMatches starts 00:00:28.186 StartMatches ends 00:00:28.187 EndMatches starts 00:00:28.188 EndMatches ends 00:00:28.410 SQLForm Initializing... 00:00:28.412 SetConnected starts 00:00:28.413 SetConnected: Connect starts 00:00:28.414 TOracleSession $09D05970 Start Session.LogOn as omar@UFFICIO_MESTRE_PUBLIC 00:00:29.203 TOracleQuery Query Start Query.Execute SQL = select to_char(userenv('SESSIONID')) from dual 00:00:29.342 TOracleQuery Query End (1 record processed) Duration = 0,14 00:00:29.343 TOracleSession $09D05970 End Duration = 0,921 00:00:29.344 SetConnected: (Dis)connect ends 00:00:29.345 SetSessionAction starts: SQL Window 00:00:29.346 TOracleQuery $080AA220 Start Query.Execute SQL = select null from dual 00:00:29.536 TOracleQuery $080AA220 End (1 record processed) Duration = 0,204 00:00:29.537 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:29.701 TOracleQuery BytesPerCharacterQuery End (1 record processed) Duration = 0,156 00:00:29.703 TOracleQuery BytesPerCharacterQuery Start Query.Execute SQL = select lengthb(nchr(20)), nchr(20) from dual 00:00:29.854 TOracleQuery BytesPerCharacterQuery End (1 record processed) Duration = 0,156 00:00:29.856 TOracleQuery $080AA220 Start Query.Execute SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end; :ACTION = SQL Window 00:00:29.935 TOracleQuery $080AA220 End Duration = 0,078 00:00:29.936 SetSessionAction ends 00:00:29.937 ExecuteConnectScript starts 00:00:29.938 TOracleQuery $080AA220 Start Query.Execute SQL = alter session set plsql_optimize_level = 2 00:00:30.027 TOracleQuery $080AA220 End Duration = 0,094 00:00:30.028 TOracleQuery $080AA220 Start Query.Execute SQL = alter session set plsql_code_type = interpreted 00:00:30.103 TOracleQuery $080AA220 End Duration = 0,078 00:00:30.104 ExecuteConnectScript ends 00:00:30.107 TOracleQuery $080AA220 Start Query.Execute SQL = select sid, serial# from v$session where audsid = userenv('SESSIONID') 00:00:30.246 TOracleQuery $080AA220 End (1 record processed) Duration = 0,141 00:00:30.248 EnableOutput starts 00:00:30.249 TOracleQuery PLSQLDevForm.EnableOutputQuery Start Query.Execute SQL = begin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end; :ENABLE = 1 :SIZE = 1000000 00:00:30.353 TOracleQuery PLSQLDevForm.EnableOutputQuery End Duration = 0,109 00:00:30.354 EnableOutput done 00:00:30.355 InitStatistics starts 00:00:30.356 TStatistics.Init starts 00:00:30.357 InitStatNames starts 00:00:30.358 select name from v$statname order by statistic# 00:00:30.359 TOracleQuery $080A9E00 Start Query.Execute SQL = select name from v$statname order by statistic# 00:00:30.555 TOracleQuery $080A9E00 End (501 records processed) Duration = 0,203 00:00:30.563 TOracleQuery $080A9E00 Start Query.Next for up to 501 records 00:00:30.660 TOracleQuery $080A9E00 End (501 records processed) Duration = 0,094 00:00:30.663 TOracleQuery $080A9E00 Start Query.Next for up to 501 records 00:00:30.751 TOracleQuery $080A9E00 End (160 records processed) Duration = 0,078 00:00:30.752 1162 statistics found 00:00:30.753 StatQuery.ReadBuffer = 1163 00:00:30.754 InitStatNames ends 00:00:30.755 StatQuery.Describe starts 00:00:30.756 TOracleQuery $080AA220 Start Query.Describe SQL = select value from v$sesstat where sid = :sid order by statistic# :SID = Null 00:00:30.821 TOracleQuery $080AA220 End Duration = 0,063 00:00:30.825 StatQuery.Describe ends 00:00:30.826 TStatistics.Init ends 00:00:30.827 StartValues: StatQuery.ReadBuffer = 1163 00:00:30.828 StartValues: StatQuery.ReadBuffer set to 1163 00:00:30.829 TOracleQuery $080AA220 Start Query.Execute SQL = select value from v$sesstat where sid = :sid order by statistic# :SID = 132 00:00:30.992 TOracleQuery $080AA220 End (1162 records processed) Duration = 0,172 00:00:30.994 InitStatistics ends 00:00:30.995 CreateQueryTabs starts 00:00:31.071 SQL Window Height = 283 00:00:31.072 SQL Grid Height = 199 00:00:31.073 SQL Panel Height = 84 00:00:31.081 GotoQueryTab 0 00:00:31.082 GotoQueryTab: QueryTabControlChanging 00:00:31.084 GotoQueryTab: QueryTabControlChange 00:00:31.085 QueryTabControlChange: Grid 00:00:31.086 QueryTabControlChange: Show EditPanel 1 00:00:31.092 QueryTabControlChange: Hide Grids 1 00:00:31.093 QueryTabControlChange: Hide Grids 2 00:00:31.094 QueryTabControlChange: GetTableName 00:00:31.095 QueryTabControlChange: SQLMessage = 00:00:31.096 GotoQueryTab done 00:00:31.106 StartMatches starts 00:00:31.107 StartMatches ends 00:00:31.108 EndMatches starts 00:00:31.109 EndMatches ends 00:00:31.110 CreateQueryTabs ends 00:00:31.117 Lock 00:00:31.123 UnLock 00:00:31.125 NavigationBookmarks.EnableButtons(Rebuild) 00:00:31.126 NavigationBookmarks: Backward=0, Forward=0 00:00:31.128 WindowAllowed(3) 00:00:31.133 WindowAllowed done 00:00:31.134 WindowAllowed(2) 00:00:31.135 WindowAllowed done 00:00:31.136 WindowAllowed(6) 00:00:31.137 WindowAllowed done 00:00:31.138 WindowAllowed(4) 00:00:31.139 WindowAllowed done 00:00:31.140 WindowAllowed(5) 00:00:31.141 WindowAllowed done 00:00:31.145 Lock 00:00:31.147 UnLock 00:00:31.149 SQLForm Executing... 00:00:31.154 GotoQueryTab 0 00:00:31.155 GotoQueryTab: QueryTabControlChanging 00:00:31.157 GotoQueryTab: QueryTabControlChange 00:00:31.158 QueryTabControlChange: Grid 00:00:31.159 QueryTabControlChange: Show EditPanel 1 00:00:31.161 QueryTabControlChange: Hide Grids 1 00:00:31.164 QueryTabControlChange: Hide Grids 2 00:00:31.165 QueryTabControlChange: GetTableName 00:00:31.166 QueryTabControlChange: SQLMessage = 00:00:31.168 GotoQueryTab done 00:00:31.177 SQLForm Executing... 00:00:31.183 Lock 00:00:31.184 TSQLThread SQLThread.Execute 00:00:31.188 TSQLThread SQLThread runs 00:00:31.190 TSQLThread SQLThread loop start 00:00:31.193 UnLock 00:00:31.201 TOracleQuery Query Start Query.Execute SQL = begin :id := sys.dbms_transaction.local_transaction_id; end; :ID = Null 00:00:31.334 TOracleQuery Query End Duration = 0,14 00:00:31.335 TOracleQuery $080AAA60 Start Query.Execute SQL = SELECT 1 FROM DUAL 00:00:31.504 TOracleQuery $080AAA60 End (1 record processed) Duration = 0,172 00:00:31.508 TOracleQuery SQLForm.TestQuery Start Query.Describe SQL = SELECT * FROM DUAL 00:00:31.577 TOracleQuery SQLForm.TestQuery End Duration = 0,063 00:00:31.582 TOracleQuery $080A9E00 Start Query.Execute SQL = select sys_context('userenv', 'current_schema') from dual 00:00:31.744 TOracleQuery $080A9E00 End (1 record processed) Duration = 0,157 00:00:31.745 TOracleQuery $080AA900 Start Query.Execute SQL = declare c integer := 0; p1 varchar2(500); p2 varchar2(500); expr varchar2(500); dblink varchar2(500); part1_type integer; object_number integer; dp integer; guard_error exception; pragma exception_init(guard_error, -16224); begin :object_type := null; :object_owner := null; :object_name := null; :sub_object := null; expr := :part1; if :part2 is not null then expr := expr \|\| '.' \|\| :part2; end if; if :part3 is not null then expr := expr \|\| '.' \|\| :part3; end if; loop begin sys.dbms_utility.name_resolve(name => expr, context => c, schema => :object_owner, part1 => p1, part2 => p2, dblink => dblink, part1_type => part1_type, object_number => object_number); if part1_type = 1 then :object_type := 'INDEX'; end if; if part1_type = 2 then :object_type := 'TABLE'; end if; if part1_type = 4 then :object_type := 'VIEW'; end if; if part1_type = 5 then :object_type := 'SYNONYM'; end if; if part1_type = 6 then :object_type := 'SEQUENCE'; end if; if part1_type = 7 then :object_type := 'PROCEDURE'; end if; if part1_type = 8 then :object_type := 'FUNCTION'; end if; if part1_type = 9 then :object_type := 'PACKAGE'; end if; if part1_type = 12 then :object_type := 'TRIGGER'; end if; if part1_type = 13 then :object_type := 'TYPE'; end if; if part1_type = 28 then :object_type := 'JAVA SOURCE'; end if; if part1_type = 29 then :object_type := 'JAVA CLASS'; end if; if :object_type is null then select object_type into :object_type from sys.all_objects where object_id = object_number; end if; exception when guard_error then raise; when others then null; end; c := c + 1; if c > 9 then dp := instr(expr, '.', -1); if dp > 0 then if :sub_object is not null then :sub_object := '.' \|\| :sub_object; end if; :sub_object := upper(substr(expr, dp + 1)) \|\| :sub_object; expr := substr(expr, 1, dp - 1); c := 0; end if; end if; exit when (:object_type is not null) or (c > 9); end loop; if :object_type is not null then if p1 is null then :object_name := p2; elsif p2 is null then :object_name := p1; if :object_name = :part1 and :part2 is not null then :sub_object := :part2; end if; if :object_name = :part2 and :part3 is not null then :sub_object := :part3; end if; else :object_name := p1; :sub_object := p2; end if; return; end if; begin if :part2 is null and :part3 is null then select 'USER', null, :part1 into :object_type, :object_owner, :object_name from sys.all_users u where u.username = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; begin if :part2 is null and :part3 is null and :deep != 0 then select 'ROLE', null, :part1 into :object_type, :object_owner, :object_name from sys.session_roles r where r.role = :part1 and rownum = 1; return; end if; exception when no_data_found then null; end; if :deep != 0 then begin if :part2 is null then select constraint_type, owner, constraint_name into :object_type, :object_owner, :object_name from sys.all_constraints c where c.constraint_name = :part1 and c.owner = :cur_schema and rownum = 1; else select constraint_type, owner, constraint_name, :part3 into :object_type, :object_owner, :object_name, :sub_object from sys.all_constraints c where c.constraint_name = :part2 and c.owner = :part1 and rownum = 1; end if; if :object_type = 'P' then :object_type := 'PRIMARY KEY'; end if; if :object_type = 'U' then :object_type := 'UNIQUE KEY'; end if; if :object_type = 'R' then :object_type := 'FOREIGN KEY'; end if; if :object_type = 'C' then :object_type := 'CHECK CONSTRAINT'; end if; return; exception when no_data_found then null; end; end if; end; :PART1 = DUAL :OBJECT_TYPE = Null :OBJECT_OWNER = Null :OBJECT_NAME = Null :PART2 = :SUB_OBJECT = Null :PART3 = :DEEP = 0 :CUR_SCHEMA = OMAR 00:00:31.833 TOracleQuery $080AA900 End Duration = 0,093 00:00:31.834 TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute SQL = select null from sys.all_mviews where owner = :object_owner and mview_name = :object_name :OBJECT_OWNER = SYS :OBJECT_NAME = DUAL 00:00:32.027 TOracleQuery PLSQLDevForm.DynamicQuery End (0 records processed) Duration = 0,188 00:00:32.030 TOracleQuery $080AA900 Start Query.Execute SQL = select column_name, data_type, virtual_column, hidden_column from sys.all_tab_cols where owner = :object_owner and table_name = :object_name and (virtual_column = 'YES' or hidden_column = 'YES') :OBJECT_OWNER = SYS :OBJECT_NAME = DUAL 00:00:32.188 TOracleQuery $080AA900 End (0 records processed) Duration = 0,156 00:00:32.204 TSQLThread SQLThread loop end 00:00:32.205 TSQLThread SQLThread loop done 00:00:32.207 TOracleQuery Query Start Query.Execute SQL = begin :id := sys.dbms_transaction.local_transaction_id; end; :ID = Null 00:00:32.290 TOracleQuery Query End Duration = 0,079 00:00:32.291 TSQLThread SQLThread transaction management done 00:00:32.293 TSQLThread SQLThread Postmessage 00:00:32.294 TSQLThread SQLThread Suspend 00:00:32.295 TSQLForm.ThreadFinished 00:00:32.297 TSQLForm.ThreadFinished: SQLThread.Suspended 00:00:32.298 SQLForm [14:19:06] 1 row selected in 1,013 seconds\|\|ThreadFinished 00:00:32.307 Lock 00:00:32.308 UnLock 00:00:32.313 EndValues: StatQuery.ReadBuffer = 1163 00:00:32.316 EndValues: StatQuery.ReadBuffer set to 1163 00:00:32.317 TOracleQuery $080AA220 Start Query.Execute SQL = select value from v$sesstat where sid = :sid order by statistic# :SID = 132 00:00:32.486 TOracleQuery $080AA220 End (1162 records processed) Duration = 0,156 00:00:32.491 Lock 00:00:32.494 UnLock 00:00:32.495 NavigationBookmarks.EnableButtons(Rebuild) 00:00:32.496 NavigationBookmarks: Backward=0, Forward=0 00:00:32.498 WindowAllowed(3) 00:00:32.499 WindowAllowed done 00:00:32.500 WindowAllowed(2) 00:00:32.501 WindowAllowed done 00:00:32.502 WindowAllowed(6) 00:00:32.503 WindowAllowed done 00:00:32.504 WindowAllowed(4) 00:00:32.505 WindowAllowed done 00:00:32.505 WindowAllowed(5) 00:00:32.506 WindowAllowed done 00:00:32.510 TOracleQuery $080A9E00 Start Query.Execute SQL = declare Lines sys.dbms_output.chararr; begin :NumLines := 10; sys.dbms_output.get_lines(lines => Lines, numlines => :NumLines); if :NumLines > 0 then :Line0 := Lines(1); end if; if :NumLines > 1 then :Line1 := Lines(2); end if; if :NumLines > 2 then :Line2 := Lines(3); end if; if :NumLines > 3 then :Line3 := Lines(4); end if; if :NumLines > 4 then :Line4 := Lines(5); end if; if :NumLines > 5 then :Line5 := Lines(6); end if; if :NumLines > 6 then :Line6 := Lines(7); end if; if :NumLines > 7 then :Line7 := Lines(8); end if; if :NumLines > 8 then :Line8 := Lines(9); end if; if :NumLines > 9 then :Line9 := Lines(10); end if; end; :NUMLINES = Null :LINE0 = Null :LINE1 = Null :LINE2 = Null :LINE3 = Null :LINE4 = Null :LINE5 = Null :LINE6 = Null :LINE7 = Null :LINE8 = Null :LINE9 = Null 00:00:32.588 TOracleQuery $080A9E00 End Duration = 0,078 00:00:32.590 GotoQueryTab 0 00:00:32.591 GotoQueryTab: QueryTabControlChanging 00:00:32.593 GotoQueryTab: QueryTabControlChange 00:00:32.594 QueryTabControlChange: Grid 00:00:32.595 QueryTabControlChange: Show EditPanel 1 00:00:32.597 QueryTabControlChange: Hide Grids 1 00:00:32.598 QueryTabControlChange: Hide Grids 2 00:00:32.599 QueryTabControlChange: GetTableName 00:00:32.600 QueryTabControlChange: SQLMessage = [14:19:06] 1 row selected in 1,013 seconds 00:00:32.601 SQLForm [14:19:06] 1 row selected in 1,013 seconds\|\|QueryTabControlChange 00:00:32.606 GotoQueryTab done 00:00:32.607 Lock 00:00:32.611 UnLock 00:00:32.622 StartMatches starts 00:00:32.623 StartMatches ends 00:00:32.624 EndMatches starts 00:00:32.625 EndMatches ends 00:00:37.583 TOracleQuery $080A9E00 Start Query.Execute SQL = select 'x' from dual 00:00:37.720 TOracleQuery $080A9E00 End (1 record processed) Duration = 0,125 00:00:37.721 TOracleQuery Query Start Query.Execute SQL = begin :id := sys.dbms_transaction.local_transaction_id; end; :ID = Null 00:00:37.789 TOracleQuery Query End Duration = 0,079 00:00:37.791 Destroying TSQLForm 00:00:37.802 Lock 00:00:37.804 UnLock 00:00:37.811 Lock 00:00:37.814 UnLock 00:00:37.816 WindowAllowed(3) 00:00:37.817 WindowAllowed done 00:00:37.817 WindowAllowed(2) 00:00:37.819 WindowAllowed done 00:00:37.820 WindowAllowed(6) 00:00:37.823 WindowAllowed done 00:00:37.824 WindowAllowed(4) 00:00:37.825 WindowAllowed done 00:00:37.825 WindowAllowed(5) 00:00:37.827 WindowAllowed done 00:00:37.828 TOracleSession $09D05970 Start Session.LogOff 00:00:37.894 TOracleSession $09D05970 End Duration = 0,062 00:00:37.995 TSQLThread SQLThread Suspend ended 00:00:37.998 Destroyed TSQLForm 00:00:37.999 UpdateChildList starts 00:00:38.000 UpdateChildList [timer] 00:00:38.001 UpdateChildList ends 00:00:45.962 FormResize 00:00:46.150 DoUpdateChildList starts 00:00:46.151 DoUpdateChildList Lock 00:00:46.156 Lock 00:00:46.157 UnLock 00:00:46.157 UpdateConnectionsChildList start 00:00:46.169 UpdateConnectionsChildList ConnectionFolders.Count = 155 00:00:46.170 UpdateConnectionsChildList CheckList.Count = 155 00:00:46.187 UpdateConnectionsChildList RemoveList.Count = 1 00:00:46.189 UpdateConnectionsChildList EndUpdate 00:00:46.191 UpdateConnectionsChildList end 00:00:46.192 DoUpdateChildList UnLock 00:00:46.197 DoUpdateChildList ends 00:00:47.305 KeepUserStats 1 00:00:47.306 PLSRandomID = 955780940 00:00:47.307 SaveUserStats 00:00:47.309 SaveUserStats Done 00:00:47.310 last send: 2020-04-28 00:00:47.331 MainForm Closing 00:00:47.332 ChangeUserPref , PlanViewType 00:00:47.334 ChangeUserPref end 00:00:47.337 ChangeUserPref Logon, Username 00:00:47.339 ChangeUserPref end 00:00:47.341 ChangeUserPref Logon, Database 00:00:47.343 ChangeUserPref end 00:00:47.344 ChangeUserPref Logon, ConnectAs 00:00:47.346 ChangeUserPref end 00:00:47.347 ChangeUserPref , LastNewsRead 00:00:47.348 ChangeUserPref end 00:00:47.349 ChangeUserPref , LastNewsItem 00:00:47.351 ChangeUserPref end 00:00:47.352 ChangeUserPref , LastUpdateItem 00:00:47.353 ChangeUserPref end 00:00:47.354 TOracleSession $09D01D10 Start Session.LogOff 00:00:47.566 TOracleSession $09D01D10 End Duration = 0,219 00:00:47.641 MainForm Closed 00:00:47.681 FormResize 00:00:47.706 ChangeUserPref LogonHistory, 00:00:47.708 ChangeUserPref DSA, 00:00:47.711 ChangeUserPref end 00:00:47.714 ChangeUserPref ColumnAssociations, 00:00:47.721 ChangeUserPref end 00:00:47.725 ChangeUserPref ImportAssociations, 00:00:47.727 ChangeUserPref end 00:00:47.729 ChangeUserPref BrowserFilters, 00:00:47.733 ChangeUserPref end 00:00:47.734 ChangeUserPref FileBrowserFolders, 00:00:47.736 ChangeUserPref end 00:00:47.737 ChangeUserPref Connections, 00:00:47.740 ChangeUserPref end 00:00:47.742 ChangeUserPref BrowserFolders, 00:00:47.744 ChangeUserPref end 00:00:47.745 ChangeUserPref SessionQueries, 00:00:47.748 ChangeUserPref end 00:00:47.754 ChangeUserPref ExternalTools, 00:00:47.757 ChangeUserPref end 00:00:47.758 ChangeUserPref Documents, 00:00:47.763 ChangeUserPref end 00:00:47.766 ChangeUserPref WebSearches, 00:00:47.770 ChangeUserPref end 00:00:47.776 ChangeUserPref Reports, 00:00:47.777 ChangeUserPref end 00:00:47.780 ChangeUserPref CurrentConnections, 00:00:47.786 ChangeUserPref end 00:00:47.788 Docking forms Destroying 00:00:47.789 MainForm Destroying 00:00:47.795 MainForm Destroyed 00:00:47.984 Finalization HTMLUnit 00:00:47.985 Finalization HTMLUnit done 00:00:48.018 Finalization PLSCommon 00:00:48.019 Finalization PLSCommon done 00:00:48.021 Finalization HTMLUnit 00:00:48.022 Finalization HTMLUnit done 00:00:48.023 Finalization DBObjectUnit 00:00:48.024 Finalization DBObjectUnit done 00:00:48.025 Finalization PlanUnit 00:00:48.027 Finalization PlanUnit done 00:00:48.028 Finalization RepUnit 00:00:48.030 Finalization RepUnit done 00:00:48.031 Finalization ReportCommon 00:00:48.032 Finalization ReportCommon done 00:00:48.035 Finalization StatUnit 00:00:48.037 Finalization StatUnit done 00:00:48.038 Finalization TotalRecallUnit 00:00:48.039 Finalization TotalRecallUnit done 00:00:48.040 Finalization RowExportUnit 00:00:48.041 Finalization RowExportUnit done 00:00:48.045 Finalization MacroUnit 00:00:48.047 Finalization MacroUnit done -----END-DEBUG.TXT------

Re: Very slow closing all windows RamosIt #61674 05/21/20 09:10 AM
Joined: Aug 1999 Posts: 22,219 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,219	Thanks for the detailed information. I can see that there are 8 seconds lost at the 38 second mark in the log file: 00:00:38.001 UpdateChildList ends 00:00:45.962 FormResize We'll investigate what might be happening at this point. We may need to send you a test version to obtain additional diagnostics. Marco Kalter Allround Automations

Re: Very slow closing all windows Marco Kalter #61675 05/21/20 10:25 AM
Joined: Mar 2005 Posts: 26 Italy R RamosIt OP Member
OP RamosIt Member R Joined: Mar 2005 Posts: 26 Italy	Thank you. I'll wait for a test version .

Re: Very slow closing all windows RamosIt #61677 05/21/20 02:29 PM
Joined: Aug 1999 Posts: 22,219 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,219	Can you let me know if you have enabled the "Automatically close unused connections" option (Preferences > Oracle / Connection)? If it is enabled, can you disable it and try again? Can you also check what happens if you try the same test without a database connection? Just start PL/SQL Developer without connecting, open a new SQL Window, and close it. Marco Kalter Allround Automations

Re: Very slow closing all windows Marco Kalter #61682 05/22/20 09:22 AM
Joined: Mar 2005 Posts: 26 Italy R RamosIt OP Member
OP RamosIt Member R Joined: Mar 2005 Posts: 26 Italy	I had "Automatically close unused connections" enabled. I disabled it and, wow, it works: i have not to wait all that time no more. Thank you very much. As concern having or not a database connection estabilished it seems to be irrelevant. In my enviroment it seems that "Automatically close unused connections" is the only cause of issue. Thank you again!

Re: Very slow closing all windows RamosIt #61683 05/22/20 11:33 AM
Joined: Aug 1999 Posts: 22,219 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,219	Thanks for your feedback. We'll investigate the issue. Marco Kalter Allround Automations

Re: Very slow closing all windows Marco Kalter #61688 05/23/20 09:30 AM
Joined: Aug 1999 Posts: 22,219 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,219	Can you download this pre-release, enable the "Close unused connections" option again, and check if it resolves the issue? 32 bit: https://www.allroundautomations.com/files/plsqldev1400b1963x32.msi 64 bit: https://www.allroundautomations.com/files/plsqldev1400b1963x64.msi Thanks in advance! Marco Kalter Allround Automations

Re: Very slow closing all windows Marco Kalter #61691 05/24/20 02:12 PM
Joined: Mar 2005 Posts: 26 Italy R RamosIt OP Member
OP RamosIt Member R Joined: Mar 2005 Posts: 26 Italy	I confirm that 32 bit pre-release (revision 1963) solves problem cause everything works fine also having "Close unused connections" enabled. I will test 64 bit version as soon as i will be in the position to use a oracle 64 bit client (next week in a server in my office that's not up in the weekend). Thank you again.

Re: Very slow closing all windows RamosIt #61693 05/25/20 07:56 AM
Joined: Aug 1999 Posts: 22,219 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,219	Great. Thanks for confirming! There is no need to test the 64 bit version as well. 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.044s Queries: 14 (0.013s) Memory: 2.6296 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-15 16:08:21 UTC
Valid HTML 5 and Valid CSS