Support Article
Query execution time on pr_sys_statusdetails table degrades
SA-47447
Summary
Query performance degrades when executing the threshold value in the pr_sys_statusdetails table.
Execution time of the below query is greater than the threshold value. delete from RSM_WORKER.pr_sys_statusdetails where pxUpdateDateTime < (select TRUNC(max(pxUpdateDateTime), 'DD') - 7 from RSM_WORKER.pr_sys_statusdetails)
Error Messages
Not Applicable
Steps to Reproduce
Run the below query.
delete from RSM_WORKER.pr_sys_statusdetails where pxUpdateDateTime < (select TRUNC(max(pxUpdateDateTime), 'DD') - 7 from RSM_WORKER.pr_sys_statusdetails)
Root Cause
The threshold value is set to 250 millisecond. The default threshold value is 500 milliseconds.
Resolution
As a local-change, increase the threshold value to 500 milliseconds (default value).
Published March 9, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.