dave.sharples

Cleaning up activity_accumulator

Discussion created by dave.sharples on Jul 7, 2017
Latest reply on Jul 14, 2017 by cf26721

Hi, as like most installations I guess our activity_Accumualtor table is massive (over 60% of our total database usage for one table). id like to clean it up and can see there is lots of rubbish in there with certain event_types (TAB_ACCESS and PAGE_ACCESS and SESSION_TIMEOUT) and as we have the tab page, all guest users hitting the login page are generating pointless records as well.

 

does anyone just delete these rows via some process to keep the size more manageable or modify the jobs to exclude certain types

 

thanks

Outcomes