1* select operation_id,operation_name from DBA_HIST_PLAN_OPERATION_NAME
SQL> /
OPERATION_ID OPERATION_NAME
------------ --------------------------------------------------
0
1 BITMAP KEY ITERATION
2 NESTED LOOPS
3 MERGE JOIN
4 HASH JOIN
5 AND-EQUAL
6 BITMAP AND
7 INTERSECTION
8 MINUS
9 BITMAP MINUS
10 GENERATE
11 BITMAP CONVERSION
12 BITMAP INDEX
13 CONNECT BY
14 CONNECT BY PUMP
15 COUNT
16 DELETE
17 UPDATE
18 FIRST ROW
19 FILTER
20 FOR UPDATE
21 FIXED TABLE
22 INLIST ITERATOR
23 INDEX
24 INDEX BUILD
25 LOAD AS SELECT
26 MULTI-TABLE INSERT
27 INTO
28 DIRECT LOAD INTO
29 COLLECTION ITERATOR
30 DOMAIN INDEX
31 PARTITION RANGE
32 PARTITION HASH
33 PARTITION LIST
34 PARTITION SYSTEM
35 PARTITION COMBINED
36 GRANULE ITERATOR
37 SEQUENCE
38 TABLE ACCESS
39 TABLE QUEUE
40 INDEX MAINTENANCE
41 FIFO BUFFER
42 WINDOW
43 TEMP TABLE TRANSFORMATION
44 SORT
45 BUFFER
46 BITMAP COMPACTION
47 BITMAP CONSTRUCTION
48 BITMAP OR
49 BITMAP MERGE
50 CONCATENATION
51 UNION-ALL
52 VIEW PUSHED PREDICATE
53 VIEW
54 REMOTE
55 SELECT STATEMENT
56 INSERT STATEMENT
57 UPDATE STATEMENT
58 MERGE STATEMENT
59 DELETE STATEMENT
60 CREATE TABLE STATEMENT
61 ALTER INDEX STATEMENT
62 CREATE INDEX STATEMENT
63 DDL STATEMENT
64 Can't Explain!!
65 TEMP TABLE GENERATION
66 TRUNCATE TEMP TABLE
67 RECURSIVE EXECUTION
68 MERGE
69 EXTERNAL TABLE ACCESS
70 BITMAP JOIN INDEX UPDATE
71 BITMAP JOIN INDEX UPDATE STATEMENT
72 VIEW HIERARCHY
73 SQL MODEL
74 MAT_VIEW ACCESS
75 MAT_VIEW REWRITE ACCESS
76 FREQUENT ITEMSET COUNTING
77 FIC ENUMERATE FEED
78 FIC LOAD BITMAPS
79 FIC LOAD ITEMSETS
80 DETECT END
81 RECURSIVE ITERATION
82 DOMAIN INDEX BUILD
83 DOMAIN INDEX PARTITION BUILD
84 FAST DUAL
85 REFERENCE MODEL
86 PX RECEIVE
87 QC SEND
88 PX SEND
89 PX COORDINATOR
90 PX BLOCK
91 PX PARTITION RANGE
92 PX PARTITION HASH
93 PX PARTITION LIST
94 WINDOW (IN SQL MODEL)
95 UNION ALL PUSHED PREDICATE
96 DST ENUMERATE FEED
97 DST DETECT END
98 DST RECURSIVE ITERATION
99 DST SPLIT
100 DECISION TREE CLASSIFICATION
101 DST PRUNE
102 JOIN FILTER
103 HASH
104 ERROR LOGGING
105 LOAD TABLE CONVENTIONAL
106 PART JOIN FILTER
107 AW SCAN
108 PARTITION REFERENCE
109 PX PARTITION REFERENCE
110 XPATH EVALUATION
111 RESULT CACHE
112 DM FEED PREDICTOR-TARGET PAIRS
113 DM SUPERVISED BINNING
114 DM HASH-BROADCAST COUNTS
115 BULK BINDS GET
116 OPTIMIZER STATISTICS GATHERING
117 UNPIVOT
118 TRANSPOSE
119 MONITORING
120 CUBE SCAN
121 JOINED CUBE SCAN
122 CUBE ACCESS
123 MAT_VIEW CUBE ACCESS
124 MAT_VIEW REWRITE CUBE ACCESS
125 CUBE TABLE SCAN
126 JOINED CUBE TABLE SCAN
127 CUBE TABLE ACCESS
128 UNION ALL (RECURSIVE WITH)
129 RECURSIVE WITH PUMP
130 CUBE JOIN
131 PX TASK
132 PX SELECTOR
133 STATISTICS COLLECTOR
134 MATCH RECOGNIZE
135 EXPRESSION EVALUATION
136 DM EXP MAX PAR
137 DM EXP MAX AGGR
138 WINDOW CONSOLIDATOR
139 FAULT-TOLERANCE BUFFER
140 XMLTABLE EVALUATION
Comment