Hi,
our server suddenly have a delay when making a connection to the database. If I try to make a connection with sqlplus "/ as sysdba", it connected very fast without a problem. but if I try to make a connection with user and password, it has delay 2-3 seconds before the "SQL>" prompt shown up. Then when I executed "exit" command, it also has delay 2-3 seconds before exiting sqlplus prompt. But every query I executed in between run smoothly and fast without any problems. This sqlplus command is executed within one same server, no server-client network involved. Ping and tnsping command both result in 0ms (because it pings itself).
Server load totally fine with 97% idle. I already tried to stop and restart the listener, but nothing changed. I hope somebody can help. If you need more information to analyze, please just ask.
Thank you before