I see a delay of of 10 to 15 seconds before the SQL> prompt appears when I connect to using the following statement:
$ sqlplus /
I have checked to make sure that oracle tracing is not set, and I verified in the $ORACLE_HOME/otrace/admin directory, and there are not .dat files existing.
I am not sure why it takes so much delay on this database alone, while it takes only 2 to 3 seconds to connect to other databases.
I even tried tnsping and the response is less than 10 ms.
Bookmarks