RSA IGL upgraded from 7.0.0 to 7.1.1 (Software Only on WebLogic with customer supplied Oracle DB)
The DB administrator complains that the t_av_event_info table has more than 50 million rows and takes up 5GB of space; is there any way to shrink/clean safely that table? Wouldn't that be recommended?
KR,
Gabriele
Hi Gabriel,
I believe it is best to open a support case for this issue to identify the reason of growth and aid you with cleanup procedures if applicable.
cc: Ian Staines
ACM-93289
Note that this table is cleaned up during purging but the space may not be reclaimed. Is the purging completing?
If the purging is completing, then the customer can either live with the 5GB of lost space or they can contact engineering for guidance on how to recover this space.
They can also do a database export and database import which will automatically recover the space from this (and other) tables.
Do not use the solution in ACM-93289 without opening a new JIRA.
Hi Gabriel,
I believe it is best to open a support case for this issue to identify the reason of growth and aid you with cleanup procedures if applicable.
cc: Ian Staines
ACM-93289