Posts Tagged ‘APPS_TS_TX_IDX’

APPS_TS_TX_DATA and APPS_TS_TX_IDX Size Keep On Increasing

May 31st, 2021, posted in Oracle Queries
Share

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.

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

Step2:
Turn OFF theSLA: Diagnostics Enabled profile option at all levels.

Step3:
Check the tables, tablespace and archive logs status

Share