Why trace files are generated for CDC activities ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Why trace files are generated for CDC activities ?

  1. #1
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78

    Angry 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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    have you got sql_trace set to true?

    Whats in the alert log?

  3. #3
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78
    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

  4. #4
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78
    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

  5. #5
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78
    Hi,

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

    Deba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width