Re: Making sense of the SQL trace file

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 11 Dec 2001 05:36:57 +1100
Message-ID: <3c150192$0$5900$afc38c87@news.optusnet.com.au>

I'm probably way off base here, but since your server is likely to contain a hunk of silicon which is clocking along at several hundred million cycles per second, I would have thought it perfectly feasible to interpolate nanoseconds (I think that's what 9 decimal places works out to, anyway!).

1/500,000,000 = 0.000000002 -which happens to be 9 digits of precision.

Presumably, going to a multi-gigahertz processor will allow Oracle 32i to get down to femtoseconds. ;-)

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Dusan Bolek" <pagesflames_at_usa.net> wrote in message
news:1e8276d6.0112100535.401de978_at_posting.google.com...


> "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 - 12:36:57 CST