I have Oracle 10.2.0.4 on AIX 5.3
I'm told that there's general slowness on the machine this morning. Machine itself isn't under any particular load but connection to the database is super slow.
Trying to connect via sqlplus on the database server:
sqlplus username - doing local connection - 45 seconds
sqlplus username@alias - using TNS - 3 minutes
sqlplus / as sysdba - 90 seconds
tnsping alias - taking 45000 msec to 48000 msec to respond.
I'm quite baffled. I was wondering if it was maybe the listener, but since a local connection without using the listener is also taking an extended period of time, I don't think that is necessarily relevant.
I have checked - there are no logon triggers.
Doesn't appear to be any auditing going on.