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/
,如需转载,请注明出处,否则将追究法律责任。