SQL> set timing on SQL> select count(1) from ta_textparameter; COUNT(1) ---------- 21810871 Executed in 1.477 seconds
SQL> alter table t_ta_textparameter add primary key (L_ROWID); Table altered Executed in 68.341 seconds
SQL> create materialized view log on t_ta_textparameter; Materialized view log created Executed in 0.227 seconds
create public database link src_14_dblink connect to hs_tabase identified by "hs_tabase" using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.30.14)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ora11g)) )';
SQL> set timing on SQL> SQL> create materialized view mv_t_textparamter_nopara 2 refresh on demand fast 3 as 4 select * from t_ta_textparameter@src_14_dblink; Materialized view created Executed in 190.153 seconds
SQL> alter session enable parallel dml; Session altered Executed in 0.01 seconds SQL> SQL> create materialized view mv_t_textparamter_para 2 refresh on demand fast 3 as 4 select /*+ parallel(a 4) */ * from t_ta_textparameter@src_14_dblink a; Materialized view created Executed in 164.659 seconds
SQL> begin 2 dbms_mview.refresh(list => 'mv_t_textparamter_nopara'); 3 end; 4 / PL/SQL procedure successfully completed Executed in 19.481 seconds SQL> begin 2 dbms_mview.refresh(list => 'mv_t_textparamter_para'); 3 end; 4 / PL/SQL procedure successfully completed Executed in 18.481 seconds
select * from v$pq_sesstat;
select * from v$px_process;
select * from v$active_session_history;
https://www.cnblogs.com/linjiqin/archive/2012/05/23/2514795.html
http://blog.itpub.net/26390465/viewspace-1795418/