APPS_TS_TX_DATA and APPS_TS_TX_IDX size keep on increasing

APPS_TS_TX_DATA and APPS_TS_TX_IDX size keep on increasing

Solution:-

Step1:
You can truncate these tables for deleting entire data without any back up.The truncate is more faster compare to delete command because data in the table is not write to roll back segments.

1. SQL>truncate table xla.XLA_DIAG_SOURCES;
2. SQL>truncate table xla.XLA_DIAG_EVENTS;


Step2:
Turn OFF the “SLA: Diagnostics Enabled” profile option at all levels.

Step3:
Check the tables, tablespace and archive logs status