V$SQL_PLAN
SQL> desc v$sql_plan;
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 ADDRESS                                                        RAW(8)
 HASH_VALUE                                                     NUMBER
 SQL_ID                                                         VARCHAR2(13)
 PLAN_HASH_VALUE                                                NUMBER
 CHILD_ADDRESS                                                  RAW(8)
 CHILD_NUMBER                                                   NUMBER
 TIMESTAMP                                                      DATE
 OPERATION                                                      VARCHAR2(60)
 OPTIONS                                                        VARCHAR2(60)
 OBJECT_NODE                                                    VARCHAR2(80)
 OBJECT#                                                        NUMBER
 OBJECT_OWNER                                                   VARCHAR2(30)
 OBJECT_NAME                                                    VARCHAR2(30)
 OBJECT_ALIAS                                                   VARCHAR2(65)
 OBJECT_TYPE                                                    VARCHAR2(40)
 OPTIMIZER                                                      VARCHAR2(40)
 ID                                                             NUMBER
 PARENT_ID                                                      NUMBER
 DEPTH                                                          NUMBER
 POSITION                                                       NUMBER
 SEARCH_COLUMNS                                                 NUMBER
 COST                                                           NUMBER
 CARDINALITY                                                    NUMBER
 BYTES                                                          NUMBER
 OTHER_TAG                                                      VARCHAR2(70)
 PARTITION_START                                                VARCHAR2(10)
 PARTITION_STOP                                                 VARCHAR2(10)
 PARTITION_ID                                                   NUMBER
 OTHER                                                          VARCHAR2(4000)
 DISTRIBUTION                                                   VARCHAR2(40)
 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
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License