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

 pavel galagan (pavelg11)
?? «????????-??????????»

?? «????????-??????????»
RU
pavelg11 Member since 2016 1 post
?? «????????-??????????»
Posted: Apr 11, 2016
Last activity: Apr 13, 2016
Posted: 11 Apr 2016 9:58 EDT
Last activity: 13 Apr 2016 7:52 EDT
Closed

to compress tables in scheme of user Pega

Hi Guys,

I want reduce place which used by Pega in my database.

Please, tell me about opportunities to compress data  used by Pega in database oracle .

Thanks!

best regards, Pavel.

To see attachments, please log in.
Data Integration

Posted: 8 years ago
Updated: 8 years ago
Posted: 12 Apr 2016 8:41 EDT
Updated: 12 Apr 2016 8:45 EDT
pavel galagan (pavelg11)
?? «????????-??????????»

?? «????????-??????????»
RU

Thanks Kevin!

I use database Oracle and i want to apply command "alter table ... compress", but it would help if above the table, there are no mass operations like "update/delete"

So, could you tell me names tables that not used for the bulk operations like UPDATE/DELETE.

I can't find this info  on your link.

To see attachments, please log in.
Posted: 8 years ago
Posted: 12 Apr 2016 15:35 EDT
Jie Long (LONGJ)
PEGA
Fellow, Software Architect, Services Engineering
Pegasystems Inc.
US

During install/upgrade, bulk update is invoked. Since 7.1.7, SQL merge/batch is enabled by default for saving class/instances.  Blob is already compressed. Some other thing may be helpful is defragmentation periodically for hot tables.

To see attachments, please log in.
Posted: 8 years ago
Posted: 13 Apr 2016 3:01 EDT
pavel galagan (pavelg11)
?? «????????-??????????»

?? «????????-??????????»
RU

Thanks Jie!

Could you explain names hot tables ?

And one more, can i use periodically "shrink cascade" for hot tables ?

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