Custom BI Reports and tables performance issue in fusion
Summary: Hi Team we are recently facing performnace issue on PAY_PAYMT_SEARCH_RESULTS_VL view and it is resolved automatically after one week.
Could you please provide details for below ponits to idetify any issues on tables or views in fusion
- Is there a database optimization (stats in table or views) that runs in Fusion. Can we see this process anywhere in Scheduled processes?
- if there is a way to find out any invalid objects or if there are way to find out any issues with weekly maintenance activity
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Tagged:
0