Slow startup Version 7.1.5.1396

[Flanagin]

Very slow startup. Below is the debug listing. Seems to be halting after preferences are load and the start of the Macro load for about 6 minutes. My macro library has three macros that are pretty simple. One is attached to the toolbar that looks at a six character string, wraps it in single quotes and then appends a comma and moves on to the next line to create in list queries from a series of 6 character text strings. I do have Norton virus checking and I can't turn it off. This started about a two months ago.

PL/SQL Developer
Version 7.1.5.1396
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2,086,784 kB (910,444 available)
Paging file : 4,024,276 kB (3,009,148 available)
Virtual memory : 2,097,024 kB (2,015,988 available)

Parameters
C:\Program Files\PLSQL Developer\PlSqlDev.exe
debugsql

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

2/25/2010 8:39:16 AM Application started
2/25/2010 8:39:16 AM InitPreferences
2/25/2010 8:39:16 AM Load C:\Program Files\PLSQL Developer\Preferences\Default = 0
2/25/2010 8:39:16 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
2/25/2010 8:39:16 AM PreferenceSet.Load OK
2/25/2010 8:39:16 AM Determine LocalPrefPath
2/25/2010 8:39:16 AM [1]: C:\Program Files\PLSQL Developer\Preferences
2/25/2010 8:39:16 AM LocalPrefPath: C:\Program Files\PLSQL Developer\Preferences\U850293
2/25/2010 8:39:16 AM Load C:\Program Files\PLSQL Developer\Preferences\U850293 = 0
2/25/2010 8:39:16 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\U850293\default.ini
2/25/2010 8:39:16 AM PreferenceSet.Load OK
2/25/2010 8:39:16 AM PreferenceSet.Load C:\Program Files\PLSQL Developer\Preferences\U850293\user.prefs
2/25/2010 8:39:16 AM PreferenceSet.Load OK
2/25/2010 8:39:16 AM InitPreferences end
2/25/2010 8:39:16 AM SortPreferenceSets
2/25/2010 8:39:16 AM - Default U850293
2/25/2010 8:39:16 AM - System Default
2/25/2010 8:39:17 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
2/25/2010 8:39:17 AM ReadString OK
2/25/2010 8:39:17 AM pfReadRegistry: "C:\Program Files\PLSQL Developer\PlSqlDev.exe" "%1"
2/25/2010 8:39:17 AM LoadPreferences
2/25/2010 8:39:17 AM LoadPreferences searching for default
2/25/2010 8:39:17 AM C:\Program Files\PLSQL Developer\Preferences\U850293\default.ini
2/25/2010 8:39:17 AM LoadPreferences NewPref := nil
2/25/2010 8:39:17 AM LoadPreferences
2/25/2010 8:39:17 AM LoadPreferences Reading preferences
2/25/2010 8:39:17 AM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
2/25/2010 8:39:17 AM ReadString OK
2/25/2010 8:39:17 AM pfReadRegistry: "C:\Program Files\PLSQL Developer\PlSqlDev.exe" "%1"
2/25/2010 8:39:17 AM LoadPreferences ReadPosition
2/25/2010 8:39:17 AM LoadPreferences ToolsBrowserItemClick(nil)
2/25/2010 8:39:17 AM LoadPreferences CreateBrowserFilters...
2/25/2010 8:39:17 AM LoadPreferences Files
2/25/2010 8:39:17 AM LoadPreferences Logon
2/25/2010 8:39:17 AM LoadPreferences Buttons
2/25/2010 8:39:17 AM LoadPreferences Printer
2/25/2010 8:39:17 AM LoadPreferences BrowserFolders
2/25/2010 8:39:17 AM LoadPreferences
2/25/2010 8:39:17 AM LoadPreferences end
2/25/2010 8:45:48 AM MacroLibFilename: C:\Program Files\PLSQL Developer\Macro\U850293.lib
2/25/2010 8:46:31 AM FormCreate Session.Connected
2/25/2010 8:46:31 AM FormCreate Logon.Executed 0
2/25/2010 8:46:31 AM FormCreate TDBNames.Make
2/25/2010 8:46:31 AM FormCreate SessionChanged
2/25/2010 8:46:31 AM SessionChanged SetDBAViews
2/25/2010 8:46:31 AM SessionChanged Authorizations.Load
2/25/2010 8:46:31 AM SessionChanged EnableAuthorizedMenus
2/25/2010 8:46:31 AM ExecuteConnectScript starts
2/25/2010 8:46:31 AM ExecuteConnectScript ends
2/25/2010 8:46:31 AM SessionChanged LoadRecentObjects
2/25/2010 8:46:31 AM SessionChanged Notify children
2/25/2010 8:46:31 AM SessionChanged Logoff secondary sessions
2/25/2010 8:46:31 AM SessionChanged SessionMode = smMulti
2/25/2010 8:46:31 AM SessionChanged EnableChildFunctions
2/25/2010 8:46:31 AM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraDb10g_home1
OracleHomeDir: c:\oracle10gr2
Found: oci.dll
Using: c:\oracle10gr2\bin\oci.dll
2/25/2010 8:46:33 AM SortPreferenceSets
2/25/2010 8:46:33 AM - Default U850293
2/25/2010 8:46:33 AM - System Default
2/25/2010 8:46:33 AM WMUpdatePopups starts
2/25/2010 8:46:33 AM LoadDesktop starts
2/25/2010 8:46:33 AM LoadDesktop ends
2/25/2010 8:46:33 AM WMUpdatePopups ends
2/25/2010 8:46:37 AM MainForm Closing
2/25/2010 8:46:37 AM ChangeUserPref , PlanViewType
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref Logon, Username
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref Logon, Database
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref Logon, ConnectAs
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref , LastNewsRead
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref , LastNewsItem
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref , LastUpdateItem
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM MainForm Closed
2/25/2010 8:46:37 AM ChangeUserPref LogonHistory,
2/25/2010 8:46:37 AM ChangeUserPref DSA,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref ColumnAssociations,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref ImportAssociations,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref BrowserFilters,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref BrowserFolders,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref SessionQueries,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref ExternalTools,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref Documents,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM ChangeUserPref Reports,
2/25/2010 8:46:37 AM ChangeUserPref end
2/25/2010 8:46:37 AM MainForm Destroying
2/25/2010 8:46:37 AM MainForm Destroyed
2/25/2010 8:46:37 AM Finalization HTMLUnit
2/25/2010 8:46:37 AM Finalization HTMLUnit done
2/25/2010 8:46:37 AM Finalization PLSCommon
2/25/2010 8:46:37 AM Finalization PLSCommon done
2/25/2010 8:46:37 AM Finalization HTMLUnit
2/25/2010 8:46:37 AM Finalization HTMLUnit done
2/25/2010 8:46:37 AM Finalization DBObjectUnit
2/25/2010 8:46:37 AM Finalization DBObjectUnit done
2/25/2010 8:46:37 AM Finalization DBNamesUnit
2/25/2010 8:46:37 AM Finalization DBNamesUnit done
2/25/2010 8:46:37 AM Finalization PlanUnit
2/25/2010 8:46:37 AM Finalization PlanUnit done
2/25/2010 8:46:37 AM Finalization RepUnit
2/25/2010 8:46:37 AM Finalization RepUnit done
2/25/2010 8:46:37 AM Finalization ReportCommon
2/25/2010 8:46:37 AM Finalization ReportCommon done
2/25/2010 8:46:37 AM Finalization TotalRecallUnit
2/25/2010 8:46:37 AM Finalization TotalRecallUnit done
2/25/2010 8:46:37 AM Finalization RowExportUnit
2/25/2010 8:46:37 AM Finalization RowExportUnit done
2/25/2010 8:46:37 AM Finalization MacroUnit
2/25/2010 8:46:37 AM Finalization MacroUnit done
2/25/2010 8:46:37 AM Finalization StatUnit
2/25/2010 8:46:37 AM Finalization StatUnit done

 

[Marco Kalter]

I'm not sure what could cause this. Can you check if your default Windows printer is accessible? This can sometimes cause delays.

Can you also check if this issue persists with the current 8.0.2 version? You can download a trial version and install it in a separate directory.

 

[Flanagin]

Default printer is locally attached USB HP All-in-one,so there isn't any network checking. I looks like its somewhere between the preferences end and the macro library load. We have a site license for v8 and I'm waiting for the guy to get back in the office to get a copy. Also, I have a local desktop and remote via VPN. Same issue is occurring with both installs. Based on other posts, checking the printer was the first thing I verified and I don't have an issue with either machine. However, turning off Virus checking isn't an option in the corporate environment - it's locked down on both machines.

 

[Flanagin]

Figured it out - I had used the Reports Feature to cascade through a set of Windows folders that I used to post SQL scripts. As the folder hierarchy grew and we switched to a Microsoft AD domain, it was slowing down the scan. I report the folders from the Report tool and now it starts up quickly again.

 

[Marco Kalter]

Okay, thanks for the information.