RE: what exactly 'tim' means in a 10046 TRACE file ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 31 Mar 2004 16:27:14 +0100
Message-Id: <s06af175.064@bristol21.bristol.ac>

> 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.

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_at_freelists.org 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
-----------------------------------------------------------------

Received on Wed Mar 31 2004 - 09:33:16 CST