I Dont Want to Miss a Thing

I could stay awake just 2 hear u breathing.
Watch u smile while u’re sleeping.
While u’re far away dreaming.
I could spend my life in this sweet surrender.
I could stay last in this moment forever.
Every moment spent with u is a moment i treasure.

I don’t wanna close my eyes.
I don’t wanna fall asleep.
‘Cause i’d miss u, baby.
And i don’t wanna miss a thing.
’cause even when i dream of u.
The sweetest dream will never do.
I’d still miss u, baby.

Lying close 2 u feeling Ur heart beating.
And i’m wondering what u’re dreaming.
Wondering if it’s me u’re seeking.
Then i kiss Ur eyes thank god we’re together.
And i just wanna stay with u.
In this moment forever, forever ever.

I don’t wanna miss one smile.
I don’t wanna miss one kiss.
Well, i just wanna be with u.
Right here with u, just like this.
I just wanna hold u close.
Feel Ur heart so close 2 mine.
And just stay here in this moment.
For all the rest of time.

Don’t wanna close my eyes.
Don’t wanna fall asleep, yeah
Don’t wanna miss a thing.

Why VKTM background process in Oracle 11g

在Oracle11g中,我们可以发现一个新的基础后台进程叫做VKTM (virtual keeper of time),这个进程是必须存在的。

在数据库启动时候的告警日志中可以看到:
VKTM started with pid=3, OS id=2256 at elevated priority
VKTM running at (20)ms precision

在数据字典中也可以查询到如下信息:


SQL> select name,description from v$bgprocess where name=’VKTM’;

NAME DESCRIPTION
—– —————————————–
VKTM Virtual Keeper of TiMe process

阅读Concepts文档可以看到对这个后台进程的解释是:

VKTM (virtual keeper of time) is responsible for providing a wall-clock time (updated every second) and reference-time counter (updated every 20 ms and available only when running at elevated priority).

我想这个解释仍然不足以描述这个进程到底是做什么的。

好吧,那这个进程到底是做什么的?

在11g之前所有的Oracle数据库后台或者前台进程如果需要获得当前时间信息,就需要调用操作系统的gettimeofday()函数或者说是相类似的函数。而VKTM进程就是专门用来获得时间信息然后将信息存放在SGA中供其它进程使用,这样其它进程当需要时间信息的时候,只要到SGA的某个内存位置去获得就好,而不用频繁调用gettimeofday()函数。毫无疑问,这样效率会更高。

在RAC测试中,Oracle 1.1.0.6版本LMSx进程获取时间信息时,可以从VKTM进程中获益大概70%的速度提升,而11.1.0.7将会更高。

同时,因为gettimeofday()函数也引发了很多bug,所以无论是RAC还是NORAC库,都将从VKTM进程中获益。