Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Making sense of the SQL trace file
"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.Received on Mon Dec 10 2001 - 07:35:21 CST