起个别名就好了
apollo@CRMG>explain plan for select /*+ parallel(vodka.bpm_actinst 8) */ * from vodka.bpm_actinst;
Explained.
apollo@CRMG>select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 2842965267
---------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 631K| 133M| 36944 (2)| 00:03:05 |
| 1 | TABLE ACCESS FULL| BPM_ACTINST | 631K| 133M| 36944 (2)| 00:03:05 |
---------------------------------------------------------------------------------
8 rows selected.
apollo@CRMG>explain plan for select /*+ parallel(t 8) */ * from vodka.bpm_actinst t;
Explained.
apollo@CRMG>select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 1683451917
-----------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
-----------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 631K| 133M| 5102 (1)| 00:00:26 | | | |
| 1 | PX COORDINATOR | | | | | | | | |
| 2 | PX SEND QC (RANDOM)| :TQ10000 | 631K| 133M| 5102 (1)| 00:00:26 | Q1,00 | P->S | QC (RAND) |
| 3 | PX BLOCK ITERATOR | | 631K| 133M| 5102 (1)| 00:00:26 | Q1,00 | PCWC | |
| 4 | TABLE ACCESS FULL| BPM_ACTINST | 631K| 133M| 5102 (1)| 00:00:26 | Q1,00 | PCWP | |
-----------------------------------------------------------------------------------------------------------------
11 rows selected.