Slow JDBC OCI Performance After Upgrading Oracle Client From 11.2.0.1 To 11.2.0.4
(Doc ID 1920196.1)
Last updated on JUNE 05, 2023
Applies to:
JDBC - Version 11.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
Flex 3.4 web application uses JDBC OCI (thick) 11.2.0.4 driver on a Linux server to connect to an 11.2.0.4 database.
The application uses a proxy account to connect from a database to the application by running dbms_session.setrole. After the upgrade of the Oracle Client from 11.2.0.1 to 11.2.0.4, the application experiences a massive slow down (response times in excess of five minutes).
Changes
Oracle Client upgrade from 11.2.0.1 to 11.2.0.4.
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 |