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.

Improve performance of Oracle Database 9i with 10g thin client drivers

Suggest edit Updated on September 25, 2019

The PegaRULES database using Oracle Database 9i with a corresponding 9i JDBC driver exhibits slow performance. The SystemPulse, SystemIndexer, and ProcessServiceLevel agents log alerts similar to the following examples:

Database query took more than threshold of 500 ms: 4,149 ms SQL: select
pzClearCacheType, pzObjClass, pzKeyString, pzParameters from pr_sys_updatescache where ((pzNodeName <> ?) or (pzNodeName is null)) and (pzCreateDateTime >= ?) and (pzCreateDateTime < ?) and (pzClearCacheType <> 'Index') order by pzCreateDateTime asc

Database query took more than threshold of 500 ms: 4,422 ms SQL: select pzClearCacheType, pzObjClass, pzKeyString, pzParameters from pr_sys_updatescache where (pzCreateDateTime >= ?) and (pzCreateDateTime < ?) order by pzCreateDateTime asc

Database operation took more than the threshold of 500 ms: 2,006 ms SQL: SELECT pzInsKey as "pxInsHandle", pxGoalTime AS "pxGoalTime", pxGoalExecute AS "pxGoalExecute", pxDeadlineTime AS "pxDeadlineTime", pxDeadlineExecute AS "pxDeadlineExecute", pxLateTime AS "pxLateTime", pyProcessOnNode AS "pyProcessOnNode", pyAssignmentStatus AS "pyAssignmentStatus", pxTaskName AS "pxTaskName" FROM pc_assign_workbasket WHERE pxObjClass = ? and (pxGoalExecute IS NOT NULL ) and (pxDeadlineExecute IS NULL ) and (pxDeadlineTime IS NOT NULL) And (pyErrorAssignment IS NULL) AND ( pxDeadlineTime < ?) and pxRefObjectKey not in (select pxLockHandle from pr_sys_locks where pxExpireDateTime > ? )

To improve database performance, you can now use Oracle 10g thin client drivers for access to Oracle 9i databases.

 

Suggested Approach

If you are using an Oracle 9i database, upgrade to a 10g thin client driver to improve performance.

Refer to the Oracle references cited below.

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