We recently upgraded from PRPC 7.2.1 to 8.5.2. Our DB folks have indicated that since the upgrade the sppr_sys_reservequeueitem_b, making a select call to pr_sys_queues, is executing millions of times per day resulting in very high cpu usage. What controls how often this proc is called related to pr_sys_queues?
If this is an ORACLE environment. can you try to alter the ORDER BY clause of the standard stored procedure sppr_sys_reservequeueitem_b:
orderby := ' order by pzInsKey ASC';
orderby := ' order by pyMinimumDateTimeForProcessing ASC';
Posted: 2 years ago
Updated: 2 years ago
Posted: 18 Aug 2021 14:10 EDT Updated: 18 Aug 2021 14:28 EDT
Mark Huseboe (MarkH960)