Title: 10046 trace data question
Thanks all, I appreciate your help.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts
Title: 10046 trace data question
Thanks everyone for your replies.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts
Title: 10046 trace data question
Does anyone know where tim= comes from? Is it from a certain epoch?
e.g.
PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5 tim=1042250821743271 hv=1053795750 ad='1eed99f0'
COMMIT
END OF STMT
PARSE #15:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim
Title: 10046 trace data question
I
believe it's from v$timer
This view lists the elapsed time in
hundredths of seconds. Time is measured since the beginning of the epoch, which
is operating system specific, and wraps around to 0 again whenever the value
overflows four bytes (roughly 497
That's in 9i...in 8i it was centiseconds.
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
Does anyone know where tim= comes from? Is it from a certain epoch?
e.g.
PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5
tim=1042250821743271 hv=1053795750 ad='1eed99f0'
COMMIT
END OF STMT
I believe that it's microseconds since the Unix epoch (1/1/1970
00:00:00 UTC).
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
Does anyone know where tim= comes from? Is it from a certain epoch?
e.g.
PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5
tim=1042250821743271 hv=1053795750
PROTECTED] Sent: Wednesday,
October 29, 2003 2:04 PMTo: Multiple recipients of list
ORACLE-LSubject: 10046 trace data question
Does anyone know where tim= comes from? Is
it from a certain epoch?
e.g. PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5
tim=1042250821743271 hv
Title: 10046 trace data question
In release 8, its V$TIMER.HSECS.
In release 9, it varies by platform. Its
the unadulterated value of gettimeofday() on our Linux server.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance
Diagnosis101: 10/28
FleurySent:
Wednesday, October 29, 2003 5:39 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: 10046 trace data question
Refer to page 133 and 134 of Cary Millsap's book, Optimizing Oracle
Performance. For his research server it is the number of elapsed
microseconds since the Unix