Index organized table and redo log it genereates
来源:互联网 发布:java 监听端口 编辑:程序博客网 时间:2024/04/30 10:19
Today, OPS team raised an issue related to a program using IOT. The program generated too many archive logs thus it took more time to FTP archive logs to our DR server and apply them. 1~4 hours lag were caused by this issue. So our focus is why this program is generating so many archived logs.
Following is my testing:
CREATE TABLE IOT_OE_ORDER_LINES
(
LINE_ID NUMBER NOT NULL PRIMARY KEY,
ORG_ID NUMBER,
HEADER_ID NUMBER NOT NULL,
LINE_TYPE_ID NUMBER NOT NULL,
LINE_NUMBER NUMBER NOT NULL,
ORDERED_ITEM VARCHAR2(2000 BYTE),
REQUEST_DATE DATE,
PROMISE_DATE DATE,
SCHEDULE_SHIP_DATE DATE,
ORDER_QUANTITY_UOM VARCHAR2(3 BYTE),
PRICING_QUANTITY NUMBER,
PRICING_QUANTITY_UOM VARCHAR2(3 BYTE)
)
ORGANIZATION INDEX;
In sqlplus, set autot trace exp stat
SQL>
INSERT INTO IOT_OE_ORDER_LINES ( LINE_ID
,ORG_ID
,HEADER_ID
,LINE_TYPE_ID
,LINE_NUMBER
,ORDERED_ITEM
,REQUEST_DATE
,PROMISE_DATE
,SCHEDULE_SHIP_DATE
,ORDER_QUANTITY_UOM
,PRICING_QUANTITY
,PRICING_QUANTITY_UOM)
SELECT * FROM (SELECT LINE_ID
,ORG_ID
,HEADER_ID
,LINE_TYPE_ID
,LINE_NUMBER
,ORDERED_ITEM
,REQUEST_DATE
,PROMISE_DATE
,SCHEDULE_SHIP_DATE
,ORDER_QUANTITY_UOM
,PRICING_QUANTITY
,PRICING_QUANTITY_UOM
FROM OE_ORDER_LINES_ALL
ORDER BY LINE_ID
)
WHERE ROWNUM < 1000;
The order by line_id clause will reduce the redo size. When I tried to insert into a heap table, it generated even less redos.
- Index organized table and redo log it genereates
- IOT(Index Organized Table)
- Index-Organized Table(IOT)
- Heap-Organized table 和 Index-Organized table 说明
- Index-Organized Table和Clustered Table
- Index-Organized Table和Clustered Table
- Index-Organized Table和Clustered Table(转)
- 简述Oracle IOT(Index Organized Table)
- 简述Oracle IOT(Index Organized Table)
- 3 Indexes and Index-Organized Tables读书笔记
- 简述Oracle IOT(Index Organized Table)(上)
- 简述Oracle IOT(Index Organized Table)(中)
- 简述Oracle IOT(Index Organized Table)(下)
- 简述Oracle IOT(Index Organized Table)(上)
- 简述Oracle IOT(Index Organized Table)(中)
- 简述Oracle IOT(Index Organized Table)(下)
- 索引组织表(index organized table, IOT)
- Mysql Redo AND Undo log
- install visualsvn
- 美国SOA协会:成功SOA部署的8个特征
- 业务科技优化 惠普BSM展露新颜
- 关于数据文件头的检查点SCN知识
- ran accross the ORA-00600: internal error code, arguments: error
- Index organized table and redo log it genereates
- 匈牙利命名
- AfxBeginThread的基本用法
- RFT中文字显示为方框的问题
- 从逻辑架构讲解SOA的精髓
- Ubuntu中文件编码转化工具 enca
- [转载]AS3 JPEG Encoder应用:从Flash中保存图片
- 初识SOAP
- Rod Johnson平衡的质疑:Spring维护策略的再次调整