Question
1
Replies
160
Views
Posted: December 4, 2017
Last activity: December 18, 2017
Closed
Solved
spprsysreservequeueitemb-stored-procedure-taking-more-time
Hi all,
We are getting messages within our PGA Rules Alert log files that above mentioned query is getting slower.
I stumbled upon below URL, but it states that this is applicable to ORACLE.
Is this also usefull in DB2?
Best, regards,
Arjan Maus
https://pdn.pega.com/support-articles/spprsysreservequeueitemb-stored-procedure-taking-more-time
***Edited by moderator, Maryrita: moved to Product Support from PegaBuzz***
Hi Arjan,
Default threshold is 500ms I think for sql operation.
We have seen that this threshold generally overshoots by meager values(500ms to 100ms) range.
If such is the case you may ignore it or get in touch of DBA for further analysis.
The post that you have referred to mentions the tuning specific to stored proc in Oracle and same may be applicable at your end.
Open the stored proc and apply it if you find Stored proc with similar code as that of mentioned in that post.
Thanks,
Ujjwal