Re: APPS_TS_TX_IDX growth rapidly.

Posted by ErmanArslansOracleBlog on Mar 09, 2021; 6:44am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/APPS-TS-TX-IDX-growth-rapidly-tp9397p9459.html

What time interval did you query? You have to query the time period when there is sudden tablespace growth.

As you see in the uploaded output, there is no big increase in the size of APPS_TS_TX_IDX or APPS_TS_TX_DATA...
So probably, you queried the wrong time interval. (remember -> you said ; you increased the tablespace size for APPS_TS_TX_DATA or IDX and then you saw a big increase there and you ended up with the full APPS_TS_TX_DATA or IDX tablespaces again. So you need to query that specific time interval to understand what object/objects are responsible for this growth.

Please revise the time condition and query again.