This discussion is archived
0 Replies Latest reply: Nov 12, 2012 3:54 AM by LiuMaclean(刘相兵) RSS

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

LiuMaclean(刘相兵) Expert
Currently Being Moderated
哪一个视图收集了所有的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上没有

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points