APEX 4.2.6
Oracle 11.2.0.4
Glassfish 4.1
Since we moved to a new server, we have sometimes the problem that logging into our application is very slow (2 to 3 minutes).
(After filling username / password
On the login page 101 I added code to start debugging
begin
APEX_DEBUG.ENABLE(9);
end;
I noted 2 cases:
- Once the Apex debug showed that my login took 0.5 sec, although actual login from the website took 2 mins.
Apparently it took a long time before a database connection was made / activated from Apex listener.
It's unclear to me how to debug this.
- Another time I found the login time in the debug output.
Now the slow command seems to be LDAP initialisation
v_ldap := dbms_ldap.init( HOSTNAME => 'ldaps.company.net', PORTNUM => 636);
After a logoff, and logon again after that, it's normally fast.
Any tips for troubleshooting?