We are headed down the path of purging legacy data from our instances to better manage our database size. I am currently working on cleaning up the email tables, one of which is sys_email_log. This table shows up on our list of top 100 tables according to size. Can someone please tell me what the data on this table is used for? I can find the same information on the sys_email table although it does allow me to query for the event that created the email and the notification used, via the list view. My hope is to keep these records around for no more than a year in case I need to track emails sent using a specific event or notification, and then handle the purging of the sys_email and sys_email_attachment tables independently?
Any guidance would be appreciated.
