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

 Pradeep Pydi (PradeepP5255)
American Express

American Express
US
PradeepP5255 Member since 2016 9 posts
American Express
Posted: May 7, 2017
Last activity: May 11, 2017
Posted: 7 May 2017 19:02 EDT
Last activity: 11 May 2017 11:57 EDT
Closed
Solved

BLOB table Contention issues.

Hi Team,

BLOB table (ORACLE DB) with high volume of insert and update queries causing Database contentions in Production.In addition, we also faced issues while trying to replicate the BLOB tables from one zone to another.

Please provide scalable implementations at other client locations which includes replication of BLOB's across other Data Centers.

To see attachments, please log in.
System Administration

Accepted Solution

Posted: 7 years ago
Posted: 7 May 2017 22:06 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

In general, you will find it helpful from this link: https://docs-previous.pega.com/db-lob-sizing-v54. You can ignore the title 'v54' as the most principles described here apply to the current Pega versions as well. 

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