深入SecureFile—新一代LOB揭秘

玉面飞龙 · 发表于 2015-5-13 07:18

最近一个insert-only的Prod DB，将LOB从basic 转为secure LOB。

	basic lob CPU per exec timing	secure lob CPU per exec timing
11203 + flashback database on	1000 us	5000 us
11203 + flashback database off		1600 us
11204 + flashback database off + _securefiles_concurrency_estimate=50		1200 us
11204 + flashback database on + _securefiles_concurrency_estimate=50		1700 us

Yong Huang · 发表于 2015-5-13 23:40

To 玉面飞龙,

Thanks for your test. Are the elapsed time stats available? Also, how about the 3 missing stats for BasicFile LOB?

[原创] 深入SecureFile—新一代LOB揭秘