Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Purge

Highlighted
Daniel U
Occasional Advisor

Data Purge

Over the past few months we have been using ITG very extensively (v6.0 sp10) and our workflow tables are growing large very quickly. This is starting to have an impact on migrations and opening certain packages that have a lot of package lines could take up to 15 minutes. Over the past 2 months, our KWFL_STEP_TRANSACTION_HISTORY table has grown by 2 million records. This problem will only get worse. There must be a smart way to approach purging some of this data, and I am wondering if anyone has gone through this and can offer some pointers.

Thanks in advance!
2 REPLIES
Jim Esler
Honored Contributor

Re: Data Purge

You do not indicate how big the table is. Ours currently has 7522169 entries and performance is fine. We are running 6.0 SP14. We are running Oracle 10.2.0.3 RAC on three Sun-Fire-V490 servers.

We have been having performance problems with the Request List portlet, though. Our DBA has been able to make dramatic improvements with the following Oracle Optimizer directives:

optimizer_index_caching integer 50
optimizer_index_cost_adj integer 50

An analysis of your database may point you toward a similar temporary solution to your performance issues. That said, we also have decided we will need a process to archive data and keep the operational database trimmed down.
Shashank Mane
Acclaimed Contributor

Re: Data Purge

Daniel,
We do have a custom purging solution for 6.0 that purges workflow transaction tables resulting in improved performance. If you need any further details, please contact me at Shashank.Mane@Patni.com.

Thanks,
Shashank
//Add this to "OnDomLoad" event