Oracle connection extremely slow(Oracle 11G on Linux RHEL4)
588495Mar 4 2008 — edited Aug 6 2013Hi guru,
In my production database connection suddenly starts taking significant time like 10-15 seconds.
even I try to connect from same machine by using following command :
sqlplus system/impetus@DB
it is taking more then 10 seconds every time
whereas if I use follwing command :
sqlplus system/impetus
connection is instant (taking only few milliseconds)
We also used tnsping which is also instant ...
any clue