Re: APPS_TS_TX_IDX growth rapidly.
Posted by
ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/APPS-TS-TX-IDX-growth-rapidly-tp9397p9445.html
Please check the size of that lob(SYS_LOB0001144624C00040$$) using the following queries;
Check the bytes
select bytes from dba_segments where segment_name ='<lob segment name>' and owner ='
';
Check the column name
SELECT TABLE_NAME, COLUMN_NAME FROM DBA_LOBS WHERE OWNER = '<owner>' AND SEGMENT_NAME= '<lob segment name>' ;
Check the size
select sum(dbms_lob.getlength (<lob column name>)) from <table_name>;