Decipher Trace files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Decipher Trace files

  1. #1
    Join Date
    Feb 2001
    Posts
    83
    Hello guys,

    I don't understand how to decipher the trace files. for example i have pasted a part from my trace file and how to find what is the message said in it.

    Thanks.


    LIBRARY OBJECT LOCK: lock=ce55ff0 handle=c8d5418 mode=N
    call pin=adb742c session pin=0
    user=ca5ca2c session=ca5ca2c count=1 flags=[00] savepoint=15071
    LIBRARY OBJECT HANDLE: handle=c8d5418
    name=SYS.STANDARD
    hash=86458414 timestamp=03-27-1999 12:11:29
    namespace=BODY flags=TIM/SML/[02000000]
    kk-dd-aa-ll=00-11-00-11 lock=N pin=0 latch=2
    lwt=c8d5430[c8d5430,c8d5430] ltm=c8d5438[c8d5438,c8d5438]
    pwt=c8d5448[c8d5448,c8d5448] ptm=c8d549c[c8d549c,c8d549c]
    ref=c8d5420[c8d5420,c8d5420]
    LIBRARY OBJECT: object=c8d5200
    type=PKBD flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
    DEPENDENCIES: count=2 size=16
    READ ONLY DEPENDENCIES: count=10 size=16
    ACCESSES: count=1 size=16
    DATA BLOCKS:
    data# heap pointer status pins change
    ----- -------- -------- ------ ---- ------
    0 c8d5cf8 c8d52c0 I/-/A 0 NONE
    4 c8d5270 c8d37c4 I/-/A 0 NONE
    ----------------------------------------
    with regards
    Prasanna S

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    use tkprof utility (provided with Oracle)

  3. #3
    Join Date
    Feb 2001
    Posts
    83
    Hello Pipo,

    This is not sqltrace file. This is .TRC file which is created in UDUMP.

    Thanks.
    with regards
    Prasanna S

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