Oracle timing units of measureThis is a featured page

Platform: Oracle App:
Tool:
DB Ver: 9.2 App Ver:
Tool Ver:
Revision Date: 01-Feb-2006 Keywords: REF, REFERENCE, TIMING, TIME UNITS, UNIT OF MEASURE

Reference Notes
SQL Plus
1. For Windows, the timing given by the SET TIMING ON command are given in microseconds (1/1,000ths of a second)
2. For Unix, the timing given by the SET TIMING ON command are given in the form HH:MM:SS.ss (2 decimal places of seconds)

Oracle RDBMS 9i +
1. The timings given on the parameters on DB calls for e= (elapsed), and on WAIT calls for ela= (elapse) are in milliseconds (1/1,000,000ths of a second)

Oracle RDBMS 7, 8
1. The timings given on the parameters on DB calls for e= (elapsed), and on WAIT calls for ela= (elapse) are in centiseconds (1/100ths of a second)




consultium
consultium 		Latest page update: made by consultium , Oct 7 2009, 12:52 PM EDT (about this update About This Update consultium Edited by consultium


view changes
- complete history)
Keyword tags: REF REFERENCE TIME UNITS TIMING UNIT OF MEASURE
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Analytical Functions (1) Index Of Oracle SQL Commands AUTOTRACE options and examples
Standard Utility scripts Login Script Raw Trace Data Stat meanings
Structure of an Extended SQL Trace file Effective MULTIBLOCK READ COUNT values used in cost calculations What IS the cost of a query and what does it mean?
Creating Reports