v$sqlarea里面的version_count和LOADED_VERSIONS有啥区别呀

lory

10g的文档里面解释

1. VERSION_COUNT NUMBER Number of child cursors that are present in the cache under this parent
   
2. LOADED_VERSIONS NUMBER Number of child cursors that are present in the cache and have their
   
3. context heap (KGL heap 6) loaded
   
4. OPEN_VERSIONS NUMBER The number of child cursors that are currently

复制代码

version_count是指该sql没有被重复使用的次数么
LOADED_VERSIONS真不明白是啥意思

Maclean Liu(刘相兵

他说的比较明确了 LOADED_VERSIONS   要求还有自身的 context heap (KGL heap 6) loaded SQLA子堆 ，实际存放 执行计划