SQLPLUS connection to database login response time was 3 minutes.!! How to Debug? At first, when we look at the Alert log file it was not showing anything as its login time issue! So login using sys/system or some different user where there is no issue on TOAD session. Now open some other window and try to login using the username having issue. Observe Session browser at the same time while system is trying to connect database. Enable Trace: After enabling trace at listener level, by changing values at sqlnet.ora file and bouncing listener. Found trace is showing some ip address which was referred to some weblogic server which was set as (unlimited failed attempt) trying to login and creating Row cache lock. As there are some changes in passwords, weblogic configuration required changes, which was causing issue.