加快insert into select速度with hints and nologging
SQL> select count(*) from aaa_partitioned_table;
COUNT(*)
----------
1000000
Executed in 0.375 seconds
SQL> truncate table aaa_partitioned;
Table truncated
Executed in 2.172 seconds
SQL> insert /*+ APPEND */ into aaa_partitioned nologging select * from aaa_partitioned_table;
1000000 rows inserted
Executed in 29 seconds
SQL> commit;
Commit complete
Executed in 0 seconds[@more@]
COUNT(*)
----------
1000000
Executed in 0.375 seconds
SQL> truncate table aaa_partitioned;
Table truncated
Executed in 2.172 seconds
SQL> insert /*+ APPEND */ into aaa_partitioned nologging select * from aaa_partitioned_table;
1000000 rows inserted
Executed in 29 seconds
SQL> commit;
Commit complete
Executed in 0 seconds[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70612/viewspace-1024090/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 自动冷备份脚本（转）
请登录后发表评论
登录
全部评论
最新文章
- 神华的早餐还不错
- oracle版本升级：从11.2.0.1到11.2.0.3
- dataguard switchover & failover steps （rac）
- 11.2.0.1 rac 2nodes asm aix6.1 orarootagent.bin swap memory内存泄漏
- ora-30004:when using sys_connect_by_path function,cannot have seperator as part of column value
- Logminer的使用以及注意事项
- oracle客户端无人值守安装 静默安装
- 关于 oracle 临时表 ORA-14452
- 关于oracle日期格式显示格式
- job_queue_processes参数 job关系
