0 Replies Latest reply: Nov 12, 2012 5:54 AM by LiuMaclean(刘相兵) RSS

    哪一个视图收集了所有的SQL OPERATION NAME? 好比HINT有一个V$SQL_HINT?

    LiuMaclean(刘相兵)
      哪一个视图收集了所有的SQL OPERATION NAME? 好比HINT有一个V$SQL_HINT?


      AS Maclean Answered:

      这个视图可能可以满足你, 但不一定全面:
      SQL> select * from v$version;
      
      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      PL/SQL Release 11.2.0.3.0 - Production
      CORE    11.2.0.3.0      Production
      TNS for Linux: Version 11.2.0.3.0 - Production
      NLSRTL Version 11.2.0.3.0 - Production
      
       1* select OPERATION_NAME from dba_hist_plan_operation_name order by  OPERATION_NAME
      SQL> /
      
      OPERATION_NAME
      ----------------------------------------------------------------
      ALTER INDEX STATEMENT
      AND-EQUAL
      APPROXIMATE NDV
      AW SCAN
      BITMAP AND
      BITMAP COMPACTION
      BITMAP CONSTRUCTION
      BITMAP CONVERSION
      BITMAP INDEX
      BITMAP JOIN INDEX UPDATE
      BITMAP JOIN INDEX UPDATE STATEMENT
      BITMAP KEY ITERATION
      BITMAP MERGE
      BITMAP MINUS
      BITMAP OR
      BUFFER
      BULK BINDS GET
      COLLECTION ITERATOR
      CONCATENATION
      CONNECT BY
      CONNECT BY PUMP
      COUNT
      CREATE INDEX STATEMENT
      CREATE TABLE STATEMENT
      CUBE ACCESS
      CUBE SCAN
      CUBE TABLE ACCESS
      CUBE TABLE SCAN
      Can't Explain!!
      DDL STATEMENT
      DECISION TREE CLASSIFICATION
      DELETE
      DELETE STATEMENT
      DIRECT LOAD INTO
      DM FEED PREDICTOR-TARGET PAIRS
      DM HASH-BROADCAST COUNTS
      DM SUPERVISED BINNING
      DOMAIN INDEX
      DOMAIN INDEX BUILD
      DOMAIN INDEX PARTITION BUILD
      DST DETECT END
      DST ENUMERATE FEED
      DST PRUNE
      DST RECURSIVE ITERATION
      DST SPLIT
      ERROR LOGGING
      EXTERNAL TABLE ACCESS
      FAST DUAL
      FIC DETECT END
      FIC ENUMERATE FEED
      FIC LOAD BITMAPS
      FIC LOAD ITEMSETS
      FIC RECURSIVE ITERATION
      FIFO BUFFER
      FILTER
      FIRST ROW
      FIXED TABLE
      FOR UPDATE
      FREQUENT ITEMSET COUNTING
      GENERATE
      GRANULE ITERATOR
      HASH
      HASH JOIN
      INDEX
      INDEX BUILD
      INDEX MAINTENANCE
      INLIST ITERATOR
      INSERT STATEMENT
      INTERSECTION
      INTO
      JOIN FILTER
      JOINED CUBE SCAN
      JOINED CUBE TABLE SCAN
      LOAD AS SELECT
      LOAD TABLE CONVENTIONAL
      MAT_VIEW ACCESS
      MAT_VIEW CUBE ACCESS
      MAT_VIEW REWRITE ACCESS
      MAT_VIEW REWRITE CUBE ACCESS
      MERGE
      MERGE JOIN
      MERGE STATEMENT
      MINUS
      MONITORING
      MULTI-TABLE INSERT
      NESTED LOOPS
      PART JOIN FILTER
      PARTITION COMBINED
      PARTITION HASH
      PARTITION LIST
      PARTITION RANGE
      PARTITION REFERENCE
      PARTITION SYSTEM
      PX BLOCK
      PX COORDINATOR
      PX PARTITION HASH
      PX PARTITION LIST
      PX PARTITION RANGE
      PX PARTITION REFERENCE
      PX RECEIVE
      PX SEND
      QC SEND
      RECURSIVE EXECUTION
      RECURSIVE WITH PUMP
      REFERENCE MODEL
      REMOTE
      RESULT CACHE
      SELECT STATEMENT
      SEQUENCE
      SORT
      SQL MODEL
      TABLE ACCESS
      TABLE QUEUE
      TEMP TABLE GENERATION
      TEMP TABLE TRANSFORMATION
      TRANSPOSE
      TRUNCATE TEMP TABLE
      UNION ALL (RECURSIVE WITH)
      UNION ALL PUSHED PREDICATE
      UNION-ALL
      UNPIVOT
      UPDATE
      UPDATE STATEMENT
      VIEW
      VIEW HIERARCHY
      VIEW PUSHED PREDICATE
      WINDOW
      WINDOW (IN SQL MODEL)
      XPATH EVALUATION
      
      
      130 rows selected.
      注意11g才有该视图, 10.2.0.5上没有