Connection To Sqlplus Slower In 19c, than in version 11g, On AIX
(Doc ID 2891054.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Connection to DBs on SQL*PLUS 19c version is slower than on version 11g.
Since customer upgraded a DB from 11g to 19c, customer jobs take more time and we have identified the latency is not in the queries but in the connection itself to the DB.
Also it appears to be platform specific as well, as we`ve seen noticeable differences between 19c on Linux and 19c on AIX.
Considering the two scripts:
time sqlplus /nolog << EOF
time sqlplus / as sysdba << EOF
Results of tests:
AIX 7.1 Oracle 11g
AIX 7.1 Oracle 18.4
AIX 7.1 Oracle 19.3
real 0m1.60s <------ replicated issue
Linux 19.13 <---- seems to have less impact on Linux platform
This might be related to Bug 30571037 - 19C SQL*PLUS TAKES 1 SECOND WHEN EXITING AN APPLICATION
We applied the patch and it improved considerably, one second less.
However, it is still slower using 19c than 11g to connect to the 19c database, and the customer batches still taking long for the application.
Using 11g to connect to the 19c database:
Using 19c to connect to the 19c database:
Upgrade from 11g to 19c
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