Why trace files are generated for CDC activities ?

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

have you got sql_trace set to true?

Whats in the alert log?

Hi davey23uk,

Thanks for the reply. But the value of sql_trace is false. I have not found any info regarding this in metalink site. Can you suggest what is the possible reason ?

Deba

Hi davey23uk,

I have found that there is one account of cdc user and that user issues command "ALTER SESSION SET EVENTS '22825 TRACE NAME CONTEXT FOREVER, LEVEL 1'".

Can anyone tell what is purpose of using this event ? Is this event generates the trace file ? what does it do on level 1 ? Is it good
for issuing this staement everry day ?

Deba

Hi,

sorry I know that event creates trace file ? wha is the purpose of using this event ?

Deba