Authentication in login page takes long time

Posted by satish on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Authentication-in-login-page-takes-long-time-tp10383.html

Dear erman,

Once we enter username and password,the page takes long time to provide the home page. How can we fix this.We verified below tables has more data.


SQL> select count(*) from fnd_logins;

  COUNT(*)
----------
  12332093

SQL> select count(*) from icx_sessions;

  COUNT(*)
----------
   1746205

SQL>

Thanks,
Satish