Trace files size increasing abnormally in the system only during sometime
Hi,
Database : Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Last one week , the trace files are generating in huge size abnormally and occupying the Disk space in the Operating system.
This huge trace files are generating only some time in a day during "gather statistics and RMAN Backup " running in the database thru CRON JOB.
*1. Could anyone please tell me why the trace files generating in huge size suddenly*
*2. what is this trace files contains?*
*3. What is this contents related to?*
*4. Is it mandatory or we can disable this Trace files?*
*4. Is it possible to check in v$session whether this files related to which Job/process/SQL running in the database?*
When i checked the content of the trace file , i found the below contents:
Trace file /opt/oracle/diag/rdbms/dws/DWS/trace/DWS_arc2_21382.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11.1.0
System name: SunOS
Node name: crs42dws2
Release: 5.10
Version: Generic_142909-17
Machine: sun4u
Instance name: DWS
Redo thread mounted by this instance: 1
Oracle process number: 58
Unix process pid: 21382, image: oracle@crs42dws2 (ARC2)
*** 2012-05-21 15:16:42.370
*** SESSION ID:(2248.19) 2012-05-21 15:16:42.370
*** CLIENT ID:() 2012-05-21 15:16:42.370
*** SERVICE NAME:(SYS$BACKGROUND) 2012-05-21 15:16:42.370
*** MODULE NAME:() 2012-05-21 15:16:42.370
*** ACTION NAME:() 2012-05-21 15:16:42.370
*** 2012-05-21 15:16:42.294 3333 kcrr.c
kcrroda: calling ksfdrcres to create AL or RL
*** 2012-05-21 15:16:45.358
*** 2012-05-21 15:16:45.357 3353 kcrr.c
kcrroda: completed call to ksfdrcres
*** 2012-05-21 15:27:14.776
*** 2012-05-21 15:27:14.776 3333 kcrr.c
kcrroda: calling ksfdrcres to create AL or RL
*** 2012-05-21 15:27:15.864
*** 2012-05-21 15:27:15.864 3353 kcrr.c
kcrroda: completed call to ksfdrcres
*** 2012-05-21 15:38:43.858 3333 kcrr.c
*** 2012-05-21 15:38:43.858
kcrroda: calling ksfdrcres to create AL or RL
*** 2012-05-21 15:38:44.977
*** 2012-05-21 15:38:44.977 3353 kcrr.c
kcrroda: completed call to ksfdrcres
*** 2012-05-21 15:58:25.144 3333 kcrr.c
Thanks and Regards,
C.DEEBAN