Table of Contents

Troubleshooting: Performance degradation with Oracle 11g JDBC drivers caused by known issue with change in Oracle Date-Time bind variable

Summary

Performance degradation occurs in deployments that have upgraded to Oracle 11g JDBC drivers. For example, SLA queries can consume a higher than expected percentage of Oracle resources, and worklists and workbaskets can become overloaded with an excessive number of work objects.

PRPC versions 5.4 and later that use Oracle 11g JDBC drivers will experience this problem because Timestamp data types passed in by JDBC are implicitly converted to Date data type, causing full table scans instead of index scans.

The hotfixes identified in the Suggested Approach correct PRPC Database Java code for Oracle JDBC to use the setObject method instead of the setTimestamp method.

The problem has been corrected in PRPC 6.2 and later releases.

Suggested Approach

Obtain and install the applicable hotfix:

For PRPC Version Obtain HFix Using This Method To Install HFix
5.4 HFix-3871 Contact Global Customer Support.

Follow the instructions in the HFix ReadMe.txt file.

5.4 SP1 HFix-3184 Contact Global Customer Support. Follow the instructions in the HFix ReadMe.txt file.
5.4 SP2 HFix-3872  Contact Global Customer Support. Follow the instructions in the HFix ReadMe.txt file.
5.4 SP3 HFix-3870 Contact Global Customer Support. Follow the instructions in the HFix ReadMe.txt file.
5.5 HFix-3873 Download and install this hotfix from the Hotfix Self-Service site. Follow the Update Manager wizard.
5.5 SP1 HFix-3874 Download and install this hotfix from the Hotfix Self-Service site. Follow the Update Manager wizard.
6.1 HFix-3875 Contact Global Customer Support. Follow the instructions in the HFix ReadMe.txt file.
6.1 SP1 HFix-3876 Download and install this hotfix from the Hotfix Self-Service site. Follow the Update Manager wizard.
6.1 SP2 HFix-3262 Download and install this hotfix from the Hotfix Self-Service site. Follow the Update Manager wizard.

Important: Before you install this hotfix, install the required hotfixes for Update Manager in Process Commander V6.1 SP2 that are identified on the Hotfix Self-Service -- PRPC Update Manager page, the PRPC Update Manager Downloads table.

References

Oracle Technology Network

Simple Data Types: What's going on with the DATE and TIMESTAMP?

Databases and Performance blog (John Brady)

Java Data Types and Oracle (2) (Thursday, 12 February 2009)

Suggest Edit

Related Content

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.