RE: timing data

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 09 Jan 2004 08:09:26 -0800
Message-ID: <F001.005DC45D.20040109080926@fatcity.com>

David,

See MetaLink Doc ID 39817.1, if you have access to MetaLink. Also, see Cary Millsap's new book: "Optimizing Oracle Performance".

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown

-----Original Message-----

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

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: Bobak, Mark
  INET: Mark.Bobak_at_il.proquest.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). Received on Fri Jan 09 2004 - 10:09:26 CST