AnsweredAssumed Answered

Large ts_defect_meta_values table

Question asked by daniele.elia on May 18, 2017
Latest reply on May 18, 2017 by Hallett_German

Hi all,
I have a problem with APM 10.2 on Oracle Db; I'm using CEM and the Db is now about 800 Gb and it seems that there are too many old data; for example in ts_defect_meta_values is 300 Gb and I see defect from 17/01/2017 and ts_defects is 7 Gb

 

I have closed all the incident and I have set :

 

under Setup -> Incident Settings

 

Delete Defect after 1 days

 

Under Setup -> Domain

 

Make Users Inactive after: 35 days
Keep Hourly User Statistics for: 1 days
Keep Daily User Statistics for: 14 days
Keep Weekly User Statistics for: 27 weeks
Keep Hourly User Group Statistics for: 1 days
Keep Daily User Group Statistics for: 14 days
Keep Weekly User Group Statistics for: 27 weeks

 

Any advise ?

 

 

Thanks,
Daniele

Outcomes