sqlplus / as sysdba to connect the database may become slow.
(Doc ID 2896519.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
1. When trying to connect to the database as sysdba or over listener , the DB is slow.
2. From strace, it is seen the slowness is on function below
strace -T -tt -o /tmp/strace_sqlplus_local.txt sqlplus / as sysdba
09:16:41.673184 fcntl(10, F_SETFD, FD_CLOEXEC) = 0
09:16:41.673230 read(11, "NTP0 72013\n", 64) = 11
09:17:21.721819 fcntl(11, F_SETFD, FD_CLOEXEC) = 0
09:17:21.722297 write(10, "\0:\0\0\1\0\0\0\1:\1,\f\1 \0\20\0O\230\0\0\1\0\0\376\0:\0\0\10\0"..., 58) = 58
09:16:41.673184 fcntl(10, F_SETFD, FD_CLOEXEC) = 0
09:16:41.673230 read(11, "NTP0 72013\n", 64) = 11
09:17:21.721819 fcntl(11, F_SETFD, FD_CLOEXEC) = 0
09:17:21.722297 write(10, "\0:\0\0\1\0\0\0\1:\1,\f\1 \0\20\0O\230\0\0\1\0\0\376\0:\0\0\10\0"..., 58) = 58
Changes
New installation
or
Migrate to new hardware
or
Migrate to new VMs
or
Change in parameters below
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |