Re: which system call is used to measure wait time ?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 07 Feb 2001 04:00:35 GMT
Message-ID: <3a80c785.22427168@nsw.nnrp.telstra.net>

Hi All,

Jonathan Lewis and I have been chasing the implementation of V$TIMER over the last few days, and it appears that what I said below only applies to Oracle8i on Solaris - if that.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: steve.adams_at_ixora.com.au (Steve Adams)

Your wait_time is wrong because you are using V$TIMER. Calls to V$TIMER read an SGA data structure. That value only changes when Oracle gets around to updating it, and so it can lag behind real time by a second or more under heavy CPU load. See http://www.ixora.com.au/q+a/0008/29072854.htm for more on that. Received on Tue Feb 06 2001 - 22:00:35 CST