You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!