oracle试图执行计划,ORACLE获得执行计划的相关视图

获取执行计划的若干视图。 1.v$sql_plan Name Null? Type ADDRESS RAW(4) HASH_VALUE NUMBER SQL_ID VARCHAR2(13) PLAN_HASH_VALUE NUMBER CHILD_ADDRESS RAW(4) CHILD_NUMBER NUMBER TIMESTAMP DATE OPERATION VARCHAR2(30) OPTIONS VARCHAR2(30) OBJECT_NODE VARCHAR2(40) OBJECT# NUMBER OBJECT_OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(30) OBJECT_ALIAS VARCHAR2(65) OBJECT_TYPE VARCHAR2(20) OPTIMIZER VARCHAR2(20) ID NUMBER PARENT_ID NUMBER DEPTH NUMBER POSITION NUMBER SEARCH_COLUMNS NUMBER COST NUMBER CARDINALITY NUMBER BYTES NUMBER OTHER_TAG VARCHAR2(35) PARTITION_START VARCHAR2(5) PARTITION_STOP VARCHAR2(5) PARTITION_ID NUMBER OTHER VARCHAR2(4000) DISTRIBUTION VARCHAR2(20) CPU_COST NUMBER IO_COST NUMBER TEMP_SPACE NUMBER ACCESS_PREDICATES VARCHAR2(4000) FILTER_PREDICATES VARCHAR2(4000) PROJECTION VARCHAR2(4000) TIME NUMBER QBLOCK_NAME VARCHAR2(30) REMARKS VARCHAR2(4000) OTHER_XML CLOB 2.v$sql_plan_statistics Name Null? Type ADDRESS RAW(4) HASH_VALUE NUMBER SQL_ID VARCHAR2(13) PLAN_HASH_VALUE NUMBER CHILD_ADDRESS RAW(4) CHILD_NUMBER NUMBER OPERATION_ID NUMBER EXECUTIONS NUMBER LAST_STARTS NUMBER STARTS NUMBER LAST_OUTPUT_ROWS NUMBER OUTPUT_ROWS NUMBER LAST_CR_BUFFER_GETS NUMBER CR_BUFFER_GETS NUMBER LAST_CU_BUFFER_GETS NUMBER CU_BUFFER_GETS NUMBER LAST_DISK_READS NUMBER DISK_READS NUMBER LAST_DISK_WRITES NUMBER DISK_WRITES NUMBER LAST_ELAPSED_TIME NUMBER ELAPSED_TIME NUMBER 3.v$sql_workarea Name Null? Type ADDRESS RAW(4) HASH_VALUE NUMBER SQL_ID VARCHAR2(13) CHILD_NUMBER NUMBER WORKAREA_ADDRESS RAW(4) OPERATION_TYPE VARCHAR2(20) OPERATION_ID NUMBER POLICY VARCHAR2(10) ESTIMATED_OPTIMAL_SIZE NUMBER ESTIMATED_ONEPASS_SIZE NUMBER LAST_MEMORY_USED NUMBER LAST_EXECUTION VARCHAR2(10) LAST_DEGREE NUMBER TOTAL_EXECUTIONS NUMBER OPTIMAL_EXECUTIONS NUMBER ONEPASS_EXECUTIONS NUMBER MULTIPASSES_EXECUTIONS NUMBER ACTIVE_TIME NUMBER MAX_TEMPSEG_SIZE NUMBER LAST_TEMPSEG_SIZE NUMBER 4.v$sql_plan_statistics_all Name Null? Type ADDRESS RAW(4) HASH_VALUE NUMBER SQL_ID VARCHAR2(13) PLAN_HASH_VALUE NUMBER CHILD_ADDRESS RAW(4) CHILD_NUMBER NUMBER TIMESTAMP DATE OPERATION VARCHAR2(30) OPTIONS VARCHAR2(30) OBJECT_NODE VARCHAR2(40) OBJECT# NUMBER OBJECT_OWNER VARCHAR2(30) OBJECT_NAME VARCHAR2(30) OBJECT_ALIAS VARCHAR2(65) OBJECT_TYPE VARCHAR2(20) OPTIMIZER VARCHAR2(20) ID NUMBER PARENT_ID NUMBER DEPTH NUMBER POSITION NUMBER SEARCH_COLUMNS NUMBER COST NUMBER CARDINALITY NUMBER BYTES NUMBER OTHER_TAG VARCHAR2(35) PARTITION_START VARCHAR2(5) PARTITION_STOP VARCHAR2(5) PARTITION_ID NUMBER OTHER VARCHAR2(4000) DISTRIBUTION VARCHAR2(20) CPU_COST NUMBER IO_COST NUMBER TEMP_SPACE NUMBER ACCESS_PREDICATES VARCHAR2(4000) FILTER_PREDICATES VARCHAR2(4000) PROJECTION VARCHAR2(4000) TIME NUMBER QBLOCK_NAME VARCHAR2(30) REMARKS VARCHAR2(4000) OTHER_XML CLOB EXECUTIONS NUMBER LAST_STARTS NUMBER STARTS NUMBER LAST_OUTPUT_ROWS NUMBER OUTPUT_ROWS NUMBER LAST_CR_BUFFER_GETS NUMBER CR_BUFFER_GETS NUMBER LAST_CU_BUFFER_GETS NUMBER CU_BUFFER_GETS NUMBER LAST_DISK_READS NUMBER DISK_READS NUMBER LAST_DISK_WRITES NUMBER DISK_WRITES NUMBER LAST_ELAPSED_TIME NUMBER ELAPSED_TIME NUMBER POLICY VARCHAR2(10) ESTIMATED_OPTIMAL_SIZE NUMBER ESTIMATED_ONEPASS_SIZE NUMBER LAST_MEMORY_USED NUMBER LAST_EXECUTION VARCHAR2(10) LAST_DEGREE NUMBER TOTAL_EXECUTIONS NUMBER OPTIMAL_EXECUTIONS NUMBER ONEPASS_EXECUTIONS NUMBER MULTIPASSES_EXECUTIONS NUMBER ACTIVE_TIME NUMBER MAX_TEMPSEG_SIZE NUMBER LAST_TEMPSEG_SIZE NUMBER 5.v$session Name Null? Type SADDR RAW(4) SID NUMBER SERIAL# NUMBER AUDSID NUMBER PADDR RAW(4) USER# NUMBER USERNAME VARCHAR2(30) COMMAND NUMBER OWNERID NUMBER TADDR VARCHAR2(8) LOCKWAIT VARCHAR2(8) STATUS VARCHAR2(8) SERVER VARCHAR2(9) SCHEMA# NUMBER SCHEMANAME VARCHAR2(30) OSUSER VARCHAR2(30) PROCESS VARCHAR2(12) MACHINE VARCHAR2(64) TERMINAL VARCHAR2(30) PROGRAM VARCHAR2(48) TYPE VARCHAR2(10) SQL_ADDRESS RAW(4) SQL_HASH_VALUE NUMBER SQL_ID VARCHAR2(13) SQL_CHILD_NUMBER NUMBER PREV_SQL_ADDR RAW(4) PREV_HASH_VALUE NUMBER PREV_SQL_ID VARCHAR2(13) PREV_CHILD_NUMBER NUMBER MODULE VARCHAR2(48) MODULE_HASH NUMBER ACTION VARCHAR2(32) ACTION_HASH NUMBER CLIENT_INFO VARCHAR2(64) FIXED_TABLE_SEQUENCE NUMBER ROW_WAIT_OBJ# NUMBER ROW_WAIT_FILE# NUMBER ROW_WAIT_BLOCK# NUMBER ROW_WAIT_ROW# NUMBER LOGON_TIME DATE LAST_CALL_ET NUMBER PDML_ENABLED VARCHAR2(3) FAILOVER_TYPE VARCHAR2(13) FAILOVER_METHOD VARCHAR2(10) FAILED_OVER VARCHAR2(3) RESOURCE_CONSUMER_GROUP VARCHAR2(32) PDML_STATUS VARCHAR2(8) PDDL_STATUS VARCHAR2(8) PQ_STATUS VARCHAR2(8) CURRENT_QUEUE_DURATION NUMBER CLIENT_IDENTIFIER VARCHAR2(64) BLOCKING_SESSION_STATUS VARCHAR2(11) BLOCKING_INSTANCE NUMBER BLOCKING_SESSION NUMBER SEQ# NUMBER EVENT# NUMBER EVENT VARCHAR2(64) P1TEXT VARCHAR2(64) P1 NUMBER P1RAW RAW(4) P2TEXT VARCHAR2(64) P2 NUMBER P2RAW RAW(4) P3TEXT VARCHAR2(64) P3 NUMBER P3RAW RAW(4) WAIT_CLASS_ID NUMBER WAIT_CLASS# NUMBER WAIT_CLASS VARCHAR2(64) WAIT_TIME NUMBER SECONDS_IN_WAIT NUMBER STATE VARCHAR2(19) SERVICE_NAME VARCHAR2(64) SQL_TRACE VARCHAR2(8) SQL_TRACE_WAITS VARCHAR2(5) SQL_TRACE_BINDS VARCHAR2(5) Clear