ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to improve the data reorg performance?

How to improve the data reorg performance?

原创 Linux操作系统 作者:flyerchen2000 时间:2010-03-01 15:38:37 0 删除 编辑
Recently storage expansion, need move data to new storage .
the sql like below:

alter table ATTR move subpartition GW201026_26 tablespace ODS1_TAB_L1 PARALLEL ;

alter index IP$ATTR$SN$TS$NAME rebuild subpartition GW201026_26 tablespace ODS1_IDX_L1 PARALLEL ;


Time spend: 40Min (22G Tab + 34G Idx)
oracle parameters as below:

SQL> show parameters parallel

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
fast_start_parallel_rollback         string
LOW
log_parallelism                      integer
1
parallel_adaptive_multi_user         boolean
TRUE
parallel_automatic_tuning            boolean
TRUE
parallel_execution_message_size      integer

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
4096
parallel_instance_group              string

parallel_max_servers                 integer
48
parallel_min_percent                 integer
0
parallel_min_servers                 integer
8

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
parallel_server                      boolean
FALSE
parallel_server_instances            integer
1
parallel_threads_per_cpu             integer
2
recovery_parallelism                 integer
6
cpu_count                            integer
256




来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/3637/viewspace-628287/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-25

  • 博文量
    43
  • 访问量
    84412