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 the “SLA: Diagnostics Enabled” profile option at all levels.
Step3:
Check the tables, tablespace and archive logs status
CAUSE :
Typically occurs when writing a new record to oracle database, but there is not enough space to write it. The data file in oracle tablespace called APPS_TS_TX_DATA should be set to AUTOEXTEND. If it is not, Oracle will not auto-increase the size of the datafile, and will raise the above error.
SOLUTION :
If all the reports end in COMPLETE – NORMAL, means its work.
If not than follow below steps.
Run a Concurrent Manager Recovery :
1. Please stop Concurrent managers by adcmctl.sh.
2. If not stopped, please abort managers by adcmctl.sh.
adcmctl.sh abort apps/****
3. Please kill if a process remains.
4. relink all (ADADMIN)
5. Please retry Concurrent Manager Recovery.
Navigate :
Oracle Applications Manager > Concurrent Managers OR Concurrent Requests > Site Map > Diagnostics and Repair > Concurrent Manager Recovery.
SOLUTION :
WARNING: This procedure should be performed by your ORACLE Database Administrator.
The SYSTEM user should have required privileges to perform this task.
Enable Autoextend on the APPS_TS_TX_DATA tablespace by executing the following Oracle PL/SQL command:
SQL > ALTER DATABASE DATAFILE '/u01/ORACLE/ORADATA/APPS_TS_TX_DATA.ORA' AUTOEXTEND ON NEXT 3072K