RE: timing data

David - I'll second Carel-Jan's suggestion. If you are this interested in this topic, you'll find Cary's book invaluable.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, January 09, 2004 10:15 AM
To: Multiple recipients of list ORACLE-L

search for tracing event 10046, or better, buy http://www.oreilly.com/catalog/optoraclep/index.html

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

> I am trying to find a reference or document that explains how timing data
> is
> collected in 8i and 9i. I can remember reading an article that stated
> that
> 9i now collects in 1/1000th or 1/1000000th of a second. I know that
> through
> the v$system_event (one of the views in the wait interface) that it is
> 1/100th of a second. Does anybody now where a document is located that
> explains this?
>
> thanks,
>
>
> David Ehresmann
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ehresmann, David
> INET: David.Ehresmann_at_ps.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: cjpengel.dbalert_at_xs4all.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).