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

 Mahendra Kumar (MahendraK9977)
BNP Paribas

BNP Paribas
IN
MahendraK9977 Member since 2017 7 posts
BNP Paribas
Posted: Jan 31, 2019
Last activity: Feb 8, 2019
Posted: 31 Jan 2019 3:37 EST
Last activity: 8 Feb 2019 3:56 EST
Closed

Deleting Rows not reducing occupied BLOB size
Hi All, One of our work table is growing in size (occupying around 250 GB space - Table size - 30 GB, BLOB Size 220 GB). There were around 20 million entries in the table so we planned to delete older entries. We deleted almost 50% of rows and brought the count to 10 million entries. As expected the table size reduced and came down, but the BLOB size remained the same. We even had our DBA do reorg of the table but it was not of much use. Environment Details Pega Version - 7.2.2 DB - Oracle 12c Would appreciate your suggestions on how to reduce the BLOB size.
To see attachments, please log in.
Data Integration

Posted: 5 years ago
Posted: 1 Feb 2019 1:23 EST
Shubham Shekhar (Shekhar_Shubham) Senior Solutions Engineer
Pegasystems Inc.
IN

Hi,

Can you try Purge and Archive OOTB feature in Pega and see if it helps?

Show More

Hi,

Can you try Purge and Archive OOTB feature in Pega and see if it helps?

https://community.pega.com/sites/default/files/help_v731/procomhelpmain.htm#tools/purgearchive/aboutpurgearchivewizard.htm

I believe this is a better option to go with.

Thanks You


Show Less
To see attachments, please log in.
Posted: 5 years ago
Posted: 1 Feb 2019 3:26 EST
Mahendra Kumar (MahendraK9977)
BNP Paribas

BNP Paribas
IN
Thanks for your reply. The older entries being deleted have couple of business criteria to be applied so OOTB Purge Archival doesn't suit our needs. Also, we have already deleted records from the table. The main issue is that the BLOB size is not getting reduced. Perhaps, someone with DB expertise can shed some light on why the BLOB size is not reducing or how to effectively reduce the BLOB size.
To see attachments, please log in.
Posted: 5 years ago
Posted: 8 Feb 2019 3:53 EST
Mahendra Kumar (MahendraK9977)
BNP Paribas

BNP Paribas
IN
Hi Nick, We tried SHIRNK SPACE. 1. Move lob to basicfile (7h) 2. Shrink (40min) 3. Move lob to securefile (9h) 4. Rebuild indexes (10min) The activity took around 16 hours to complete but it freed up only 200 MB of space.
To see attachments, please log in.
Posted: 5 years ago
Posted: 8 Feb 2019 3:56 EST
Mahendra Kumar (MahendraK9977)
BNP Paribas

BNP Paribas
IN
Hi, We tried SHIRNK SPACE. 1. Move lob to basicfile (7h) 2. Shrink (40min) 3. Move lob to securefile (9h) 4. Rebuild indexes (10min) The activity took around 16 hours to complete but it freed up only 200 MB of space.
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