Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Question Unanswered: question about trace files

    Hi,

    I've installed a new database, v10.2 on Win2003 SE SP1

    When I stop and start the database, I get trace files in my bdump & udump directory. If this would happen once, that wouldn't be a problem, but I get it each time, so those directory's will be full of trace files. I don't know what they mean for and how to stop generating it.

    here a 3 types of them:
    Dump file e:\oracle\admin\test\bdump\test_lgwr_1956.trc
    Wed Dec 21 13:27:16 2005
    ORACLE V10.2.0.1.0 - Production vsnsta=0
    vsnsql=14 vsnxtr=3
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the OLAP and Data Mining options
    Windows Server 2003 Version V5.2
    CPU : 1 - type 586, 1 Physical Cores
    Process Affinity : 0x00000000
    Memory (Avail/Total): Ph:208M/383M, Ph+PgF:618M/927M, VA:1748M/2047M
    Instance name: test

    Redo thread mounted by this instance: 1
    Oracle process number: 6
    Windows thread id: 1956, image: ORACLE.EXE (LGWR)

    *** SERVICE NAME: () 2005-12-21 13:27:16.387
    *** SESSION ID: (56.1) 2005-12-21 13:27:16.387
    Maximum redo generation record size = 156160 bytes
    Maximum redo generation change vector size = 150672 bytes

    ************************************************** **
    ************************************************** **

    Dump file e:\oracle\admin\test\udump\test_ora_1672.trc
    Wed Dec 21 13:43:48 2005
    ORACLE V10.2.0.1.0 - Production vsnsta=0
    vsnsql=14 vsnxtr=3
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the OLAP and Data Mining options
    Windows Server 2003 Version V5.2
    CPU : 1 - type 586, 1 Physical Cores
    Process Affinity : 0x00000000
    Memory (Avail/Total): Ph:211M/383M, Ph+PgF:625M/927M, VA:1753M/2047M
    Instance name: test

    Redo thread mounted by this instance: 0 <none>
    Oracle process number: 12
    Windows thread id: 1672, image: ORACLE.EXE (SHAD)

    *** SERVICE NAME: () 2005-12-21 13:43:48.303
    *** SESSION ID: (50.1) 2005-12-21 13:43:48.303
    kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
    ************************************************** ****
    ************************************************** ****
    what is that kccsga_update_ckpt?
    ****************************
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the OLAP and Data Mining options
    Windows Server 2003 Version V5.2
    CPU : 1 - type 586, 1 Physical Cores
    Process Affinity : 0x00000000
    Memory (Avail/Total): Ph:244M/383M, Ph+PgF:738M/927M, VA:1777M/2047M
    Instance name: test

    Redo thread mounted by this instance: 0 <none>
    Oracle process number: 0
    Windows thread id: 1796, image: ORACLE.EXE (SHAD)

    KCCDEBUG_LEVEL = 0
    Dynamic strand is set to TRUE
    Running with 1 shared and 10 private strand(s). Zero-copy redo is FALSE
    ************************************************** *****
    what is dynamic strand?

    are there for those 'things' parameters to be set?
    thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Redo thread mounted by this instance: 0 <none>
    Based upon the above & only as a guess, but this instance "appears" to be running without ANY actual redo log files.
    I would not have thought is possible, & I don't want to hassle any such experiment.

    HTH & YMMV!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Arrow

    in my alert_log, at database startup, it gives:

    current log# 3 seq# 12 mem# 0 e:\oracle\oradata\test\redo03.log

    also when querying v$log, I got one current and two inactive

    also when doing alter database backup controlfile to trace noresetlogs, the tracefile I then get gives also 3 redologs.

    This could maybe a bug in the tracelogging of Oracle?

Posting Permissions

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