Re: APPS_TS_TX_IDX growth rapidly.

Posted by ErmanArslansOracleBlog on Mar 06, 2021; 8:38am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/APPS-TS-TX-IDX-growth-rapidly-tp9397p9442.html

What is the size of your WF_NOTIFICATION_OUT table/queue ?
According to your query outputs, it seems lobs on wf_notification_out are growing fast..

This seems related with USER_DATA columns  WF_NOTIFICATIONS_OUT.

Check your wf_notifications_out -- its size and row count and the things stored in it, especially in user_date column.. Check these with your functional admins and analyze your workflow engine & configuration.. It seems there is a big workflow activity happening in your system..