select
  ADDRESS,                                 -- ADDRESS RAW(8)
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  PLAN_HASH_VALUE,                         -- PLAN_HASH_VALUE NUMBER
  CHILD_ADDRESS,                           -- CHILD_ADDRESS RAW(8)
  CHILD_NUMBER,                            -- CHILD_NUMBER NUMBER
  TIMESTAMP,                               -- TIMESTAMP DATE
  OPERATION,                               -- OPERATION VARCHAR2(30)
  OPTIONS,                                 -- OPTIONS VARCHAR2(30)
  OBJECT_NODE,                             -- OBJECT_NODE VARCHAR2(40)
  OBJECT#,                                 -- OBJECT# NUMBER
  OBJECT_OWNER,                            -- OBJECT_OWNER VARCHAR2(30)
  OBJECT_NAME,                             -- OBJECT_NAME VARCHAR2(30)
  OBJECT_ALIAS,                            -- OBJECT_ALIAS VARCHAR2(65)
  OBJECT_TYPE,                             -- OBJECT_TYPE VARCHAR2(20)
  OPTIMIZER,                               -- OPTIMIZER VARCHAR2(20)
  ID,                                      -- ID NUMBER
  PARENT_ID,                               -- PARENT_ID NUMBER
  DEPTH,                                   -- DEPTH NUMBER
  POSITION,                                -- POSITION NUMBER
  SEARCH_COLUMNS,                          -- SEARCH_COLUMNS NUMBER
  COST,                                    -- COST NUMBER
  CARDINALITY,                             -- CARDINALITY NUMBER
  BYTES,                                   -- BYTES NUMBER
  OTHER_TAG,                               -- OTHER_TAG VARCHAR2(35)
  PARTITION_START,                         -- PARTITION_START VARCHAR2(64)
  PARTITION_STOP,                          -- PARTITION_STOP VARCHAR2(64)
  PARTITION_ID,                            -- PARTITION_ID NUMBER
  OTHER,                                   -- OTHER VARCHAR2(4000)
  DISTRIBUTION,                            -- DISTRIBUTION VARCHAR2(20)
  CPU_COST,                                -- CPU_COST NUMBER
  IO_COST,                                 -- IO_COST NUMBER
  TEMP_SPACE,                              -- TEMP_SPACE NUMBER
  ACCESS_PREDICATES,                       -- ACCESS_PREDICATES VARCHAR2(4000)
  FILTER_PREDICATES,                       -- FILTER_PREDICATES VARCHAR2(4000)
  PROJECTION,                              -- PROJECTION VARCHAR2(4000)
  TIME,                                    -- TIME NUMBER
  QBLOCK_NAME,                             -- QBLOCK_NAME VARCHAR2(30)
  REMARKS,                                 -- REMARKS VARCHAR2(4000)
  OTHER_XML                                -- OTHER_XML CLOB
from
  GV$SQL_PLAN
where
  inst_id = USERENV('Instance')