Re: APPS_TS_TX_IDX growth rapidly.

Posted by raiq1 on Mar 03, 2021; 11:16pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/APPS-TS-TX-IDX-growth-rapidly-tp9397p9422.html

Dear ermaan sir,

Today also tablespace are growing very fast.

i have find one site where useful queries, check the below link and update which query is suitable for us.

http://db.geeksinsight.com/2012/10/15/scripts-databasetabletablespace-growth-report-using-awr/


main thing is which segment/objects are growing very fast in APPS_TS_TX_DATA & APPS_TS_TX_IDX , BOTH  tablespace are growing rapidly.

Kindly check above link and update me.

Regards,