he growth of the PS_SCC_SFA_MSG_MAP table
We have concerns regarding the growth of the PS_SCC_SFA_MSG_MAP table in our environment. Currently, a new record is being stored for every message for each individual student, even though from a functional perspective we only reference the most recent message.
As a result, the table size is increasing rapidly and could pose performance and storage concerns over time.
We are exploring options to better manage this? As there any Oracle-delivered cleanup utilities, processes, or MOS notes addressing this table? Is there anyone have any system in place they like to share?
Thanks!!
Tagged:
1