Oracle数据库的deferred_segment_creation和segment creation immediate
来源:互联网 发布:mysql workbench 下载 编辑:程序博客网 时间:2024/04/29 21:57
[oracle@rhel63single ~]$ sqlplus scott/aaaaaaSQL*Plus: Release 11.2.0.4.0 Production on Sat Apr 8 02:54:40 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter deferNAME TYPE VALUE------------------------------------ ----------- ------------------------------deferred_segment_creation boolean TRUESQL> create table testa(reg_id number,reg_name varchar2(200)) segment creation immediate;Table created.SQL> create table testb(reg_id number,reg_name varchar2(200)) ;Table created.SQL> create table testc(reg_id number,reg_name varchar2(200)) segment creation deferred;Table created.SQL> select segment_name from user_segments where segment_name in( 'TESTA','TESTB','TESTC');SEGMENT_NAME--------------------------------------------------------------------------------TESTASQL> select segment_name from user_extents where segment_name in( 'TESTA','TESTB','TESTC');SEGMENT_NAME--------------------------------------------------------------------------------TESTASQL>
总结:
1.create table的参数 segment creation immediate 的优先级高于数据库初始化参数deferred_segment_creation
2.create table的参数 segment creation immediate 的反义参数是segment creation deferred
0 0
- Oracle数据库的deferred_segment_creation和segment creation immediate
- Oracle 11g的Deferred Segment Creation
- 关于oracle数据库段segment的总结
- Oracle 11gR2 deferred segment creation 与 exp/imp 说明
- Oracle 11gR2 deferred segment creation 与 exp/imp 说明
- Oracle Initialization Parameters:DEFERRED_SEGMENT_CREATION
- oracle参数之DEFERRED_SEGMENT_CREATION
- Oracle 中deferred_segment_creation 的用法以及exp时解决办法
- oracle deferred_segment_creation 段延迟分配的一个隐患
- 11.2.0.2中对Deferred Segment Creation的增强
- 查询Oracle数据库段SEGMENT和对象大小
- oracle alter kill和alter kill immediate会话的区别
- Oracle shutdown immediate无法关闭数据库解决方法
- Oracle shutdown immediate无法关闭数据库解决方法
- Oracle shutdown immediate无法关闭数据库解决方法
- Oracle数据库在没有open的状态下shutdown immediate报错
- oracle 11g使用deferred_segment_creation 延迟段创建特性时遇到的问题总结
- oracle 11g使用deferred_segment_creation 延迟段创建特性时遇到的问题总结
- C语言习题(1)——字符串拷贝,去空格,奇偶抽取字符串
- SpringMVC的视图解析器
- HDU6029-Graph Theory
- [codewars]2.编写一个maskify函数,把字符串除了后四位用“#”代替
- 中国地震台网
- Oracle数据库的deferred_segment_creation和segment creation immediate
- UVA 508 莫尔斯电码,map的妙用,函数的组合
- 语义分割SegNet
- JavaScript创建JSON对象
- 全速前行的专栏
- 初始jsp
- DPCM 压缩系统的实现和分析
- 十道海量数据处理面试题与十个方法大总结
- 9种对肝脏有益的中药