Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Surya Mokka (SuryaMokka)
Apple Inc

Apple Inc
US
SuryaMokka Member since 2018 16 posts
Apple Inc
Posted: Jun 12, 2020
Last activity: Nov 17, 2020
Posted: 12 Jun 2020 18:23 EDT
Last activity: 17 Nov 2020 7:31 EST
Closed

SPPR_DEFRAGMENT_TABLE - insufficient privileges to run procedure

Hi,

I have a Pega8.1 system and in the log files, I notice that the SPPR_DEFRAGMENT_TABLE tries to run but can't because there are insufficient privileges. I'm told that the database ID can't have permissions to create and drop tables which are required for this procedure.

I see in the DSS that I can disable the defrag by setting "syslocks/defragEnabled" to false.

What is the negative consequence by not running the defrag? What tables need to be defragmented and how often? What are the Best Practices on table defragmentation?

***Edited by Moderator: Pallavi to change content type from Discussion to Question***  

To see attachments, please log in.
Pega Platform
Case Management
Lead System Architect

  • Pratik Agarwal
Posted: 4 years ago
Posted: 17 Nov 2020 7:31 EST
Pratik Agarwal (pratik)
Cognizant
Architect
Cognizant
GB

@SuryaMokka  I see that part of your question is related to BUG-519827.

Caused due to ORA-01031: insufficient privileges for SPPR_DEFRAGMENT_TABLE.

I am currently waiting for Pegasystems to come back with an answer to this problem.

If you have anything else on this, please do share.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice