oracle的并行功能，本例只是索引的建立

QL> set timing on;
SQL> create index inv_date_no on inv_transactions_log_bk(date_no);

Index created

Executed in 274.047 seconds

SQL> drop index INV_DATE_NO;

Index dropped

Executed in 0.047 seconds

SQL> create index inv_date_no on inv_transactions_log_bk(date_no) nologging;

Index created

Executed in 189.875 seconds

SQL> drop index INV_DATE_NO;

Index dropped

Executed in 0.047 seconds

SQL> create index inv_date_no on inv_transactions_log_bk(date_no) parallel 3 nologging;

Index created

Executed in 334.906 seconds

[@more@]

create index ind_name on table_name(column) parallel degree;

PARALLEL_MAX_SERVERS specifies the maximum number of parallel execution processes and parallel recovery processes for an instance.

SQL> show parameter PARALLEL_MAX_SERVERS;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
parallel_max_servers integer 5

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

转载于:http://blog.itpub.net/700806/viewspace-1019112/