Hello,
we are currently migrating our databases from 12c to 19c. Establishing a database connection with sqlplus or sqlldr has always taken about 0.1 seconds. But when I use Client version 19 connecting to a database version 19.22, it takes 0.5 seconds on average. This is not a long time, but I wonder if there's something I can do to speed it up and if you guys think that 0.5 seconds is usually an acceptable time. The increase of connection time only occurs when both client and server have version 19.
Test with one client machine having client 12 and 19 installed and two database servers, one with version 12c and one with version 19.22:
Client 12, Server 12 → 0.1 seconds
Client 12, Server 19 → 0.1 seconds
Client 19, Server 12 → 0.1 seconds
Client 19, Server 19 → 0.5 seconds
I would assume that this might be normal due to changes in the authentication process, but I'm not sure. All machines in the upper test scenario run on Suse Linux Enterprise Server 15 SP6 (x86_64).
Thanks for all replies.