Skip to Content
avatar image
Former Member

Oracle : User trace

Hi All,

This installation is a dual stack installation with usage type (EPC, EP). DB is unicode.

Today, I found following traces in the usertrace folder. These traces are

gcbepd:oraed3 43> pg ed3_ora_20913.trc

/oracle/ED3/saptrace/usertrace/ed3_ora_20913.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

ORACLE_HOME = /oracle/ED3/102_64

System name: HP-UX

Node name: gcbepd

Release: B.11.23

Version: U

Machine: ia64

Instance name: ED3

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Unix process pid: 20913, image: oracle@gcbepd

KCCDEBUG_LEVEL = 0

Dynamic strand is set to TRUE

Running with 2 shared and 0 private strand(s). Zero-copy redo is FALSE

gcbepd:oraed3 44>

gcbepd:oraed3 44> pg ed3_ora_20937.trc

/oracle/ED3/saptrace/usertrace/ed3_ora_20937.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

ORACLE_HOME = /oracle/ED3/102_64

System name: HP-UX

Node name: gcbepd

Release: B.11.23

Version: U

Machine: ia64

Instance name: ED3

Redo thread mounted by this instance: 0 <none>

Oracle process number: 13

Unix process pid: 20937, image: oracle@gcbepd (TNS V1-V3)

  • SERVICE NAME:() 2008-06-06 13:01:11.276

  • SESSION ID:(84.1) 2008-06-06 13:01:11.276

kccsga_update_ckpt: num_1 = 50, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0

gcbepd:oraed3 45>

This server has been installed on 30.05.08. These traces has come on 30.05.08 / 31.05.08 and today (06.06.08)

Any clue, why are these traces getting generated?

Please advise.

Thanks & Regards

Sudip

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 06, 2008 at 11:00 AM

    Did you dynamically change any SGA parameters since (without restarting the instance)?

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Markus Doehr

      Hi Markus,

      Thanks for the reply. I was checking the database alert and come accross these traces. Thought to verify because I do not have knowledge about these traces.

      Thanks for help.

      With Regards

      Sudip