Skip to main content

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

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

Suggest edit Updated on September 10, 2021

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 VersionObtain HFix Using This MethodTo Install HFix
5.4HFix-3871Contact Global Customer Support.

Follow the instructions in the HFix ReadMe.txt file.

5.4 SP1HFix-3184Contact Global Customer Support.Follow the instructions in the HFix ReadMe.txt file.
5.4 SP2HFix-3872 Contact Global Customer Support.Follow the instructions in the HFix ReadMe.txt file.
5.4 SP3HFix-3870Contact Global Customer Support.Follow the instructions in the HFix ReadMe.txt file.
5.5HFix-3873Download and install this hotfix from the Hotfix Self-Service site.Follow the Update Manager wizard.
5.5 SP1HFix-3874Download and install this hotfix from the Hotfix Self-Service site.Follow the Update Manager wizard.
6.1HFix-3875Contact Global Customer Support.Follow the instructions in the HFix ReadMe.txt file.
6.1 SP1HFix-3876Download and install this hotfix from the Hotfix Self-Service site.Follow the Update Manager wizard.
6.1 SP2HFix-3262Download 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)

Did you find this content helpful? YesNo

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us