加快索引创建速度

alter session set workarea_size_policy=MANUAL;
alter session set db_file_multiblock_read_count=512;
alter session set sort_area_size=734003200;
alter session set events '10351 trace name context forever, level 128';
alter session set "_sort_multiblock_read_count"=128;
alter session enable parallel dml;
create index xxx parallel 8 nologging;
alter index xxx noparallel;

posted @ 2022-05-19 21:38  罗小川的博客  阅读(53)  评论(0编辑  收藏  举报