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.
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?