slow startup with version 10 when loading desktop and a pinning question

stefanz

Member²
Hi,

I have an issue with Version 10.0.1.1694. The startup takes about 30 Seconds or more, even when I press cancel at startup to prevent logging on.
I have started with the option DebugSql. And based on the log, it seems the time is lost trying to connect to all the connections of the different windows in the desktop being loaded.

I see several entries like this one:
...
30.03.2013 09:16:59 LoadDesktop WindowName =
30.03.2013 09:16:59 TOracleSession $0352FBE0 Start Session.LogOn as xxxx@yyyy
30.03.2013 09:17:05 TOracleSession $0352FBE0 End
Result = ORA-12545: CONNECT nicht erfolgreich, da Ziel-Host oder -Objekt nicht vorhanden
Duration = 5.366
..

As a second, minor (but maybe related issue). I unpinned all connections, closed PLSQL Developer restarted without loggin in. It was still slow, after startup all unpinned connections
were pinned again.

And third, maybe I misunderstand the feature. But when I login just for one window to another user, then immediately unpin the connection, I would expect it to follow the main connections, once changed. However this is not the case, it remains with the original connection, even when unpinned.

Stefan

edit:
the third point above seems to be related to what has been reported inhttps://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=46522#Post46522

 
Last edited:
ORA-12545: CONNECT nicht erfolgreich, da Ziel-Host oder -Objekt nicht vorhanden
It can indeed be a problem if databases for the loaded window connections are not available. Is this indeed the case?

As a second, minor (but maybe related issue). I unpinned all connections, closed PLSQL Developer restarted without loggin in. It was still slow, after startup all unpinned connections
were pinned again.

And third, maybe I misunderstand the feature. But when I login just for one window to another user, then immediately unpin the connection, I would expect it to follow the main connections, once changed. However this is not the case, it remains with the original connection, even when unpinned.
This is indeed a known issue. It will be fixed in the next patch release.
 
Now this is great customer service, easter saturday support.

Yes indeed, the database was not available. This usually happens on my notebook when I am on the road or at home and vpn is not connected.

I assumed, canceling logging in during startup would also not try to reconnect pinned connections. So maybe we need a "do not logon" pinned connection option in the gui or is there alreay a startup option to not connect or can the timeout be reduced?

Stefan
 
Last edited:
just tried the nologon command line option. unfortunately this does not work, it still takes long to start

I can still see the failed connections in debug.txt
 
very good, points 2 and 3 from the initial post for my use cases, the new version 10.0.2 now properly connects as expected.

there is just on point left, point 1:
when the db instances are not available, it still takes 5 seconds per window to start up even when pressing cancel during startup login. This time however, there are no timeout messages in the log anymore, just a gap of 5 seconds for each window:

log from a startup with cancel and not available instances:
(gap after LoadDesktop WindowName =)

...
07.04.2013 12:08:09 UnLock
07.04.2013 12:08:09 LoadDesktop WindowName =
07.04.2013 12:08:15 LoadDesktop Window = 1
07.04.2013 12:08:15 WindowAllowed(1)
07.04.2013 12:08:15 WindowAllowed done
07.04.2013 12:08:15 Create TSQLForm Start
07.04.2013 12:08:15 Create TSQLForm Inherited
07.04.2013 12:08:15 TSQLForm.FormCreate Start
07.04.2013 12:08:15 Lock
07.04.2013 12:08:15 UnLock
07.04.2013 12:08:15 SQLForm
07.04.2013 12:08:15 TSQLForm.FormCreate Finished
07.04.2013 12:08:15 AddNavigationBookmark starts
07.04.2013 12:08:15 AddNavigationBookmark GNV00002
07.04.2013 12:08:15 NavigationBookmarks.EnableButtons(Rebuild)
07.04.2013 12:08:15 NavigationBookmarks: Backward=2, Forward=0
07.04.2013 12:08:15 AddNavigationBookmark ends
07.04.2013 12:08:15 Create TSQLForm SetupMainFont
07.04.2013 12:08:15 Create TSQLForm Activate
07.04.2013 12:08:15 Create TSQLForm Activate done
07.04.2013 12:08:15 Create TSQLForm UpdateWindowList
07.04.2013 12:08:15 UpdateChildList starts
07.04.2013 12:08:15 Create TSQLForm Positioning
07.04.2013 12:08:15 Create TSQLForm Finished
07.04.2013 12:08:15 LoadDesktop ChildListIndex = 1
07.04.2013 12:08:15 Lock
07.04.2013 12:08:15 UnLock
07.04.2013 12:08:15 Lock
07.04.2013 12:08:15 UnLock
07.04.2013 12:08:15 Lock
07.04.2013 12:08:15 UnLock
07.04.2013 12:08:15 FileAge: xxxxxxx.sql = 22:05:10
07.04.2013 12:08:15 SQLForm
07.04.2013 12:08:15 Lock
07.04.2013 12:08:15 UnLock
07.04.2013 12:08:15 LoadDesktop WindowName =
07.04.2013 12:08:20 LoadDesktop Window = -1
07.04.2013 12:08:20 Lock
07.04.2013 12:08:20 UnLock
07.04.2013 12:08:20 NavigationBookmarks.EnableButtons(Rebuild)
 
Back
Top