RE: what exactly 'tim' means in a 10046 TRACE file ?
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 31 Mar 2004 16:27:14 +0100
> Let me know. On Windows, I haven't looked too hard, mostly because our
> Profiler code does the simultaneous clock-walk thing, which does
> everything we want, without having to worry about platform
> dependencies.
Hi
Well getTickCount was an interesting side alley since it measures in
milliseconds - not microseconds doh! However the examples that I am seeing are
almost certainly the elapsed time in milliseconds since system boot. The
windows API does give a couple of calls to establish timings at this resolution
in kernel32.dll these are queryperformancecounter which gives the count of
clock ticks since system boot and queryperformancefrequency which gives the
resolution of the clock. This obviously relies on the hardware having a high
resolution clock - which my systems do. Short of attaching to the process and
monitoring API calls it would appear that these are the calls that Oracle uses
on MS Windows.
If anyone is interested I can post some vb.net code which I used in my tests to
the web.
Cheers
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
- Follow-Ups:
- RE: what exactly 'tim' means in a 10046 TRACE file ?
- From: Cary Millsap
Other related posts:
- » what exactly 'tim' means in a 10046 TRACE file ?
- » RE: what exactly 'tim' means in a 10046 TRACE file ?
- » RE: what exactly 'tim' means in a 10046 TRACE file ?
- » RE: what exactly 'tim' means in a 10046 TRACE file ?
- » RE: what exactly 'tim' means in a 10046 TRACE file ?
- » RE: what exactly 'tim' means in a 10046 TRACE file ?
- » RE: what exactly 'tim' means in a 10046 TRACE file ?
- » RE: what exactly 'tim' means in a 10046 TRACE file ?
- RE: what exactly 'tim' means in a 10046 TRACE file ?
- From: Cary Millsap