Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What's unit of CPU_TIME & ELAPSED_TIME columns in v$sqlarea

88657Nov 28 2006 — edited Apr 26 2013

Hi,

Oracle 9.2.0.4 on Solaris 9.
What is the time unit of CPU_TIME & ELAPSED_TIME columns in v$sqlarea?
The Database Reference says it is in microseconds (1/1000 seconds?).

My java code would get the query result even before the database engine finishes parsing the query string. Either the doc is wrong, or the data in the v$sqlarea is not right.

It seems to me that the unit should be 1/1000000 seconds.
Anybody knows what the unit really is in those columns?

Thanks,
Harry

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2013

Added on Nov 28 2006

#general-database-discussions

4 comments

6,304 views