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

Step1: Truncate these tables:-


SQL>truncate table xla.XLA_DIAG_SOURCES;

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

===============================

No comments:

Post a Comment