Hi,

We have CDC implemented in our database for DW. But I can see that good amount of trace files are generated which are related to CDC activities.

Why these files are generated ? Is there any way to stop it ?

I am pasting contents of one of those trace files.

Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
ORACLE_HOME = /u01/app/oracle/product/9.2.0
System name: SunOS
Node name: piranha
Release: 5.9
Version: Generic_112233-08
Machine: sun4u
Instance name: STPROD1
Redo thread mounted by this instance: 1
Oracle process number: 65
Unix process pid: 13329, image: oracle@piranha (TNS V1-V3)

*** SESSION ID:(55.11002) 2003-12-31 05:00:02.026
Partitioning enabled = TRUE
BEGIN EXECUTE IMMEDIATE 'ALTER TABLE CDCUSER.SDC_CAMPAIGN_MONTH_CDC SPLIT PARTITION p1 AT (2161476797) INTO (PARTITION p2, PARTITION p1) PARALLEL'; EXECUTE IMMEDIATE 'ALTER TABLE CDCUSER.SDC_CAMPAIGN_MONTH_CDC DROP PARTITION p2'; END;
Partitioning enabled = TRUE
BEGIN EXECUTE IMMEDIATE 'ALTER TABLE CDCUSER.TRF_PRODUCT_CDC SPLIT PARTITION p1 AT (2161476797) INTO (PARTITION p2, PARTITION p1) PARALLEL'; EXECUTE IMMEDIATE 'ALTER TABLE CDCUSER.TRF_PRODUCT_CDC DROP PARTITION p2'; END;
Partitioning enabled = TRUE
BEGIN EXECUTE IMMEDIATE 'ALTER TABLE CDCUSER.TRF_COMMODITY_SUB_GROUP_CDC SPLIT PARTITION p1 AT (2161476797) INTO (PARTITION p2, PARTITION p1) PARALLEL'; EXECUTE IMMEDIATE 'ALTER TABLE CDCUSER.TRF_COMMODITY_SUB_GROUP_CDC DROP PARTITION p2'; END;
Partitioning enabled = TRUE

Contents of another trace file is

Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
ORACLE_HOME = /u01/app/oracle/product/9.2.0
System name: SunOS
Node name: piranha
Release: 5.9
Version: Generic_112233-08
Machine: sun4u
Instance name: STPROD1
Redo thread mounted by this instance: 1
Oracle process number: 49
Unix process pid: 890, image: oracle@piranha (TNS V1-V3)

*** 2003-12-31 04:02:31.025
*** SESSION ID:(66.6296) 2003-12-31 04:02:31.021
UPDATE sys.cdc_system$ SET minor_version=1 WHERE minor_version=0
COMMIT
UPDATE sys.cdc_system$ SET minor_version=1 WHERE minor_version=0
COMMIT
UPDATE sys.cdc_system$ SET minor_version=1 WHERE minor_version=0
COMMIT
UPDATE sys.cdc_system$ SET minor_version=1 WHERE minor_version=0
COMMIT

regards

Deba