This view lists the elapsed time in hundredths of seconds. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes (roughly 497 days).

上面给出的是Oracle关于v$timer的说明:Oracle内部相对时钟,单位是1/100秒,自OS启动开始记录;

SQL> select * from v$timer;

HSECS
----------
4161285187

SQL> select power(2,32)/100/60/60/24 from dual;

POWER(2,32)/100/60/60/24
------------------------
497.102696296296

也就大约497天多一点;

与此相关的是Oracle的一个Bug:导致dbms_job无法运行，eygle在文章中对此作了详细说明:

http://www.eygle.com/case/Job.Can.Not.Execute.Auto.htm

ITPub博客

v$timer

最新文章