Hi,IFS developed a workaround for us to improve performance to display large amounts of data by using Materialized View (MV). The MV refresh job runs every hour to keep the data reasonably fresh for users.The Light Cleanup job should run every 10 min. It normally takes around 3-4 seconds but when the MV refresh background job is running, the Light Cleanup is taking about 30 min. - a major change. Do we have someone here who could explain why the Light Cleanup execution would increase so dramatically? What can we do to mitigate it?Sometimes, the MV refresh also gets killed by the Light Cleanup. A similar case is in this useful thread:For clarity, we have Managed Cloud Services with Apps 10, so not much access to the DB. Our case with Platinum Support is not moving fast enough and consulting is prioritizing other topics at the moment, hence my question in the Community.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.