Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Making sense of the SQL trace file
Not being a hardware guy, I had exactly the same question. Someone
suggested to me that you can get this sort of time accuracy from the
network, but I forget the details. I can chase it up again if you're really
interested.
-- HTH. Additions and corrections welcome. Pete Author of "Oracle8i: Architecture and Administration Exam Cram" Currently writing the "Oracle9i New Features for Administrators Exam Cram" "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA "Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0112100535.401de978_at_posting.google.com...Received on Mon Dec 10 2001 - 09:47:36 CST
> "K Gopalakrishnan" <kaygopal_at_yahoo.com> wrote in message
news:<0ac3v9.07d.ln_at_zstux.ita.pwr.wroc.pl>...
> > 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?
>
> The same goes to timestamp function. This is a new feature in Oracle
> 9i. By default it display system time with seconds precision to 6
> decimal place. It can even be forced to display 9 places.
> I can't imagine, how can I get this precision from ordinary server. I
> encounter this while I attended Oracle 9i - New features fo developers
> course. I have put a question, however the lecturer doesn't have a
> faintest idea about it (among with almost any other things I dare to
> ask).
> So If someone can sher a light upon me, I'll be grateful. I did some
> tests and using six places precision Oracle shows a full number,
> however using nine decimal places precision I got only six numbers and
> three zeros.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.