RE: 10046 trace data question

2003-10-31 Thread Jamadagni, Rajendra
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

RE: 10046 trace data question

2003-10-30 Thread Jamadagni, Rajendra
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

10046 trace data question

2003-10-29 Thread Jamadagni, Rajendra
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

RE: 10046 trace data question

2003-10-29 Thread Khedr, Waleed
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

Re: 10046 trace data question--addendum

2003-10-29 Thread Paul Baumgartel
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

Re: 10046 trace data question

2003-10-29 Thread Paul Baumgartel
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

RE: 10046 trace data question

2003-10-29 Thread Tim Fleury
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

RE: 10046 trace data question

2003-10-29 Thread Cary Millsap
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

RE: 10046 trace data question

2003-10-29 Thread Henry Poras
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