-
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
----------------------------------------
-
use tkprof utility (provided with Oracle)
-
Hello Pipo,
This is not sqltrace file. This is .TRC file which is created in UDUMP.
Thanks.
