最初由 jxc_hn 发布
[B]
单个extent一样可以并行查询.
SQL>select /*+ parallel(t2,3) */ * from t2;
.....
SQL> select * from user_extents where SEGMENT_NAME='T2';
SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME EXTENT_ID BYTES BLOCKS
-------------------------------------------------------------------------------- ------------------------------ ------------------ ------------------------------ ---------- ---------- ----------
T2 TABLE USERS 0 5242880 640
SQL> select * from v$px_process;
SERVER_NAME STATUS PID SPID SID SERIAL#
----------- --------- ---------- --------- ---------- ----------
P002 IN USE 19 1552 18 2
P001 IN USE 18 1556 17 7
P000 IN USE 17 1576 15 63
SQL> select * from v$px_session;
SADDR SID SERIAL# QCSID QCSERIAL# QCINST_ID SERVER_GROUP SERVER_SET SERVER# DEGREE REQ_DEGREE
-------- ---------- ---------- ---------- ---------- ---------- ------------ ---------- ---------- ---------- ----------
026D578C 16 204 16
026D4F20 15 63 16 204 1 1 1 1 3 3
026D5FF8 17 7 16 204 1 1 1 2 3 3
026D6864 18 2 16 204 1 1 1 3 3 3 [/B]