Re: APPS_TS_TX_IDX growth rapidly.

Posted by ErmanArslansOracleBlog on Feb 25, 2021; 2:46pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/APPS-TS-TX-IDX-growth-rapidly-tp9397p9398.html

Thanks for the feedback raiq1. Doing my best to help..

This  APPS_TS_TX_IDX is an transactional index tablespace. So normally, if you didn't accidentally create a custom table there, that space is used by transactional apps indexes.

You can check the index growth using db_hist_snapshot and db_hist_seg_stat tables.
In dba_hist_seg_stat table we have a  table named SPACE_USED_DELTA.
So you can write a query and get the object growth report for the objects in APPS_TS_TX_IDX..

According to your findings, I can recommend an action plan for you.. But! first you need to find the object/objects stored in APPS_TS_TX_IDX tablespace and growing rapidly in last few days..