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