Re: Making sense of the SQL trace file

Jonathan,

I wonder how oracle gets time in millseconds. Except for Solaris and linux most of the Operating systems clocks in Centiseconds. How oracle gets time in Milliseconds when the OS slices it in centiseconds?

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message news:9utfui014f8_at_drn.newsguy.com...
> In article <1007825710.2791.0.nnrp-13.9e984b29_at_news.demon.co.uk>,
"Jonathan
> says...
> >
> >It's worth bearing in mind, though, that Oracle 9
> >has started producing times in microseconds.
> >(including tim=). However there are a number of
> >minor glitches and anomalies of use in the first
> >releases.
> >
>
> where you might notice this right off (as I did ;) is on NT. Say you
install
> 9i -- well, they forgot to include tkprof (contact support, they can get
it for
> you easily, just a couple hundred k in size). Well, I have the 8i tkprof
still
> and if you use that, your timings come out TRULY huge ;) So, if you see
> thousands of CPU seconds on NT, thats what happened (using the wrong
tkprof)
>
Received on Sun Dec 09 2001 - 17:17:56 CST