What are the measurement types for all the numeric values reported in the SGA trace tool? For example, what is the Elapse Time reported as; milliseconds, seconds?
All numeric values in the SGA Trace tool are measured in microseconds.
The SGA Trace tool uses a query involving the v$sqlarea Oracle object. The link below is a describe of the v$sqlarea object:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2129.htm
NOTE: 1 microsecond is 1/1000th of a millisecond
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center