Re: APPS_TS_TX_IDX growth rapidly.

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

Use the previous query not this one..
Use that previous query but modify it to query the correct time interval..

You said you increased the tablespace size at time1
Then you said, you checked it at time2 and saw that all the newly added space was allocated..
So you should query the time interval between time1 and time2, you got the idea right?