Best Practices for Better Performance
- Increase in the number of sub-items and it's count in one item or portfolio; number of forms and dashboards with more tabs will also affect performance.
- The number of items in a single portfolio should not exceed 500. If required, break large portfolios down into sub-portfolios that roll up to a portfolio of portfolios.
- Use non-calculating portfolios to organize thousands of items in one portfolio without incurring a negative impact to performance.
- If there are more number of immediate actions, it could affect the performance of the function engine. Try to minimize the immediate actions.
- If large amounts of data need to be processed, do so during off-peak hours.
- Oracle recommends that you run the Database Clean up Utility on a regular basis (from the application console).
- Try to minimize UI data updates when there is a heavy load on the function engine.