Re: APPS_TS_TX_IDX growth rapidly.

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

Seems good.. It works good..
To be able to query the up-to-date data, you may consider taking an AWR snapshot before using it..
EXEC dbms_workload_repository.create_snapshot;

But it seems okay..

So add a condition for querying only the APPS_TS_TX_IDX 's segments and execute this query.
What is the output?