Re: APPS_TS_TX_IDX growth rapidly.

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

Sorry Raiq... Really sorry, I checked the wrong column.. The right column to check was Growth in MB..

So, the growth is caused by SYS_LOB0001144624C00040$$

What is the output of the following query ->

SELECT OBJECT_NAME, OBJECT_TYPE, STATUS FROM DBA_OBJECTS WHERE OBJECT_ID = '0001144624';