_ADD_COL_OPTIM_ENABLED参数
来源:互联网 发布:知画的孩子是永琪的吗 编辑:程序博客网 时间:2024/06/05 15:39
参考自:
Init.ora Parameter "_ADD_COL_OPTIM_ENABLED" [Hidden] Reference Note (文档 ID 1492674.1)
This parameter is set to true by default if Parameter:COMPATIBLE >= 11 . The parameter relates specifically to the actions taken by Oracle for DDL of the form:
In this very specific case of adding a NOT NULL column which has a DEFAULT value then Oracle has 2 options to perform this DDL:ALTER TABLE .. ADD COLUMN ( ... NOT NULL DEFAULT xxx )
- Before 11g or if _ADD_COL_OPTIM_ENABLED = FALSE:
The DDL will cause the column to be added to the table defintion and every row of the table is updated with the new column and its default value. For large tables the update of all rows to add a column can take some time. - In 11g onwards provided _ADD_COL_OPTIM_ENABLED = TRUE:
The DDL adds the column to the table definition but there is no update of the actual table rows. Instead the dictionary stores a flag so that it knows that any row without the column value present should return the DEFAULT value instead. For large tables this can be much faster than option "1". Any code path that accesses the table has to honour the flag otherwise it may not return the correct data for the column.
ADD COLUMN
commands. Once a column has been added using the optimized method a flag in the dictionary indicates that specific column as being optimized.You can check which columns have been ADDed with the optimization active using SQL of the form below :
If you encounter a bug issue related to _ADD_COL_OPTIM_ENABLED then typically any column listed by the above SQL might be affected. A workaround is typically to set _ADD_COL_OPTIM_ENABLED = FALSE and then recreate the problem table so that none of the columns show as optimized.select owner, object_name, name from dba_objects, col$ where bitand(col$.PROPERTY,1073741824)=1073741824 and object_id=obj#;
0 0
- _ADD_COL_OPTIM_ENABLED参数
- $参数
- 参数++
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 参数
- 命令行参数,程序参数
- 形式参数,实际参数
- this参数 扩展参数
- DecimalFormat
- css3 Media jquery尺寸适应整理 (iPhone/iPad/Galaxy/HTC One etc.)
- 隐藏状态栏的两种方法
- Oracle的基本数据类型有些怎么使用
- 8行代码教你搞定导航控制器全屏滑动返回效果!
- _ADD_COL_OPTIM_ENABLED参数
- JPush推送服务集成
- poj 1128 Frame Stacking(拓扑排序+DFS(递归))
- jquery grid表格checkbox的关联勾选与取消
- 使用thinkphp+dwz博客总结
- 2818: Gcd
- Java获取当前日期时间
- 抛弃mysql模糊查询,使用sphinx做专业索引
- poj 3122 Pie