2 Replies Latest reply: Jul 15, 2009 4:13 PM by Srini Chavali-Oracle RSS

    Bdump: MMON Trace files

    Adeel Ahmed
      MMon trace files are getting created frequently in bdump with the following content

      $ more mor_m001_3353.trc
      /u01/app/oracle/admin/mor/bdump/mor_m001_3353.trc
      Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
      ORACLE_HOME = /u01/app/oracle/product/10.2.0
      System name: SunOS
      Node name: *****
      Release: 5.10
      Version: Generic_127127-11
      Machine: sun4u
      Instance name: mor
      Redo thread mounted by this instance: 1
      Oracle process number: 38
      Unix process pid: 3353, image: oracle@***** (m001)

      *** ACTION NAME:(Auto ADDM Slave Action) 2009-07-15 00:00:25.408
      *** MODULE NAME:(MMON_SLAVE) 2009-07-15 00:00:25.408
      *** SERVICE NAME:(SYS$BACKGROUND) 2009-07-15 00:00:25.408
      *** SESSION ID:(237.770) 2009-07-15 00:00:25.408
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0

      $ more mor_m001_4696.trc
      /u01/app/oracle/admin/mor/bdump/mor_m001_4696.trc
      Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
      ORACLE_HOME = /u01/app/oracle/product/10.2.0
      System name: SunOS
      Node name: *****
      Release: 5.10
      Version: Generic_127127-11
      Machine: sun4u
      Instance name: mor
      Redo thread mounted by this instance: 1
      Oracle process number: 40
      Unix process pid: 4696, image: oracle@***** (m001)

      *** ACTION NAME:(Auto ADDM Slave Action) 2009-07-13 21:00:08.510
      *** MODULE NAME:(MMON_SLAVE) 2009-07-13 21:00:08.510
      *** SERVICE NAME:(SYS$BACKGROUND) 2009-07-13 21:00:08.510
      *** SESSION ID:(96.2250) 2009-07-13 21:00:08.510
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0
      [kdl_trim]: newlen: 0

      please find the number of time it is created since 2 weeks.
      Jul 3 00:01 mor_m001_4034.trc
      Jul 3 01:00 mor_m001_5394.trc
      Jul 3 02:00 mor_m001_6815.trc
      Jul 3 12:01 mor_m001_21286.trc
      Jul 3 16:00 mor_m001_26442.trc
      Jul 3 23:00 mor_m001_5404.trc
      Jul 4 10:00 mor_m001_20274.trc
      Jul 4 11:01 mor_m001_21559.trc
      Jul 4 12:00 mor_m001_22619.trc
      Jul 4 13:00 mor_m001_24008.trc
      Jul 4 14:00 mor_m001_25349.trc
      Jul 4 15:00 mor_m001_26751.trc
      Jul 4 16:01 mor_m001_28126.trc
      Jul 4 16:41 mor_dw01_29040.trc
      Jul 4 17:00 mor_m001_29534.trc
      Jul 4 18:00 mor_m001_575.trc
      Jul 4 19:00 mor_m001_1659.trc
      Jul 5 11:00 mor_m001_22980.trc
      Jul 5 12:00 mor_m001_24192.trc
      Jul 5 13:04 mor_m001_25672.trc
      Jul 5 14:00 mor_m001_26778.trc
      Jul 5 15:00 mor_m001_28151.trc
      Jul 5 16:00 mor_m001_29435.trc
      Jul 5 17:00 mor_m001_769.trc
      Jul 5 19:00 mor_m001_2814.trc
      Jul 6 09:00 mor_m001_17790.trc
      Jul 6 10:01 mor_m001_19271.trc
      Jul 6 11:00 mor_m001_20395.trc
      Jul 6 12:00 mor_m001_21705.trc
      Jul 6 13:00 mor_m001_23056.trc
      Jul 6 14:00 mor_m001_24351.trc
      Jul 6 15:01 mor_m001_25571.trc
      Jul 6 16:00 mor_m001_27443.trc
      Jul 6 19:00 mor_m001_1416.trc
      Jul 6 23:00 mor_m001_5646.trc
      Jul 7 09:00 mor_m001_10364.trc
      Jul 7 10:00 mor_m001_11731.trc
      Jul 7 11:00 mor_m001_13192.trc
      Jul 7 12:01 mor_m001_14507.trc
      Jul 7 13:00 mor_m001_15726.trc
      Jul 7 14:00 mor_m001_17169.trc
      Jul 7 15:00 mor_m001_18488.trc
      Jul 7 16:00 mor_m001_19922.trc
      Jul 7 17:01 mor_m001_21046.trc
      Jul 7 22:01 mor_m001_26357.trc
      Jul 7 23:00 mor_m001_27362.trc
      Jul 8 00:00 mor_m001_28462.trc
      Jul 8 10:00 mor_m001_9545.trc
      Jul 8 11:00 mor_m001_10740.trc
      Jul 8 12:00 mor_m001_12050.trc
      Jul 8 13:00 mor_m001_13413.trc
      Jul 8 14:00 mor_m001_14690.trc
      Jul 8 15:00 mor_m001_16064.trc
      Jul 8 17:00 mor_m001_18465.trc
      Jul 8 18:01 mor_m001_19484.trc
      Jul 8 23:01 mor_m001_24695.trc
      Jul 9 00:00 mor_m001_25792.trc
      Jul 9 09:00 mor_m001_5491.trc
      Jul 9 10:00 mor_m001_6777.trc
      Jul 9 11:00 mor_m001_8108.trc
      Jul 9 12:00 mor_m001_9386.trc
      Jul 9 14:00 mor_m001_12108.trc
      Jul 9 15:00 mor_m001_13332.trc
      Jul 9 17:00 mor_m001_15434.trc
      Jul 9 23:00 mor_m001_21726.trc
      Jul 10 23:00 mor_m001_15104.trc
      Jul 11 09:00 mor_m001_26027.trc
      Jul 11 11:00 mor_m001_28694.trc
      Jul 11 12:00 mor_m001_48.trc
      Jul 11 13:00 mor_m001_1407.trc
      Jul 11 14:00 mor_m001_2749.trc
      Jul 11 15:00 mor_m001_4119.trc
      Jul 11 16:01 mor_m001_5408.trc
      Jul 11 17:00 mor_m001_6579.trc
      Jul 11 22:00 mor_m001_11834.trc
      Jul 11 23:00 mor_m001_12925.trc
      Jul 12 00:00 mor_m001_13962.trc
      Jul 12 09:00 mor_m001_23674.trc
      Jul 12 10:01 mor_m001_25086.trc
      Jul 12 11:00 mor_m001_26621.trc
      Jul 12 12:00 mor_m001_27851.trc
      Jul 12 13:00 mor_m001_29006.trc
      Jul 12 14:00 mor_m001_408.trc
      Jul 12 15:01 mor_m001_1695.trc
      Jul 12 16:00 mor_m001_3030.trc
      Jul 12 17:00 mor_m001_4112.trc
      Jul 12 18:00 mor_m001_5224.trc
      Jul 12 19:00 mor_m001_6249.trc
      Jul 13 00:00 mor_m001_11493.trc
      Jul 13 09:00 mor_m001_21211.trc
      Jul 13 10:00 mor_m001_22541.trc
      Jul 13 11:01 mor_m001_23834.trc
      Jul 13 12:00 mor_m001_24853.trc
      Jul 13 13:00 mor_m001_25912.trc
      Jul 13 14:00 mor_m001_27085.trc
      Jul 13 15:00 mor_m001_28132.trc
      Jul 13 16:00 mor_m001_29251.trc
      Jul 13 17:00 mor_m001_478.trc
      Jul 13 18:00 mor_m001_1584.trc
      Jul 13 19:00 mor_m001_2602.trc
      Jul 13 20:00 mor_m001_3686.trc
      Jul 13 21:00 mor_m001_4696.trc
      Jul 13 22:00 mor_m001_5779.trc
      Jul 13 23:00 mor_m001_6811.trc
      Jul 14 09:00 mor_m001_16007.trc
      Jul 14 10:00 mor_m001_17221.trc
      Jul 14 11:00 mor_m001_18368.trc
      Jul 14 12:00 mor_m001_19559.trc
      Jul 14 13:01 mor_m001_20937.trc
      Jul 14 14:00 mor_m001_22149.trc
      Jul 14 15:00 mor_m001_23568.trc
      Jul 14 16:00 mor_m001_24872.trc
      Jul 14 17:00 mor_m001_26043.trc
      Jul 14 19:00 mor_m001_28125.trc
      Jul 14 20:00 mor_m001_29158.trc
      Jul 14 21:00 mor_m001_260.trc
      Jul 14 23:00 mor_m001_2269.trc
      Jul 15 00:00 mor_m001_3353.trc
      Jul 15 09:00 mor_m001_13106.trc
      Jul 15 10:00 mor_m001_14515.trc
      Jul 15 11:00 mor_m001_15827.trc
      Jul 15 12:00 mor_m001_17190.trc

      Is it normal message when Automatic Workload Repository is gathering statistics

      please suggest what i have to action

      Thanks
      Adeel Ahmed Syed
        • 1. Re: Bdump: MMON Trace files
          669771
          Hi,

          Solution
          1) These trace files are unnecessary and we can disregard them.
          Or
          2)Apply the patch for the unpublished 6972843 if its available for your OS.
          If Patch is not available for your OS than raise an ticket with Oracle support requesting for one-off patch

          http://oracle-principlesupport.blogspot.com/2009/02/every-hour-produces-sidm001xxxxtrc-file.html

          Regards,
          Tom
          • 2. Re: Bdump: MMON Trace files
            Srini Chavali-Oracle
            Pl see MOS Doc 567307.1 (After Upgrading To 10.2.0.4 Receiving Mmon Trace Files With Message [kdl_trim]: newlen)

            The contents of the link posted in the previous reply seem to be a cut-and-paste from the above MOS Doc - doing so is illegal and violates Support policy :-)

            HTH
            Srini