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
  EXECUTIONS,                              -- EXECUTIONS NUMBER
  LAST_STARTS,                             -- LAST_STARTS NUMBER
  STARTS,                                  -- STARTS NUMBER
  LAST_OUTPUT_ROWS,                        -- LAST_OUTPUT_ROWS NUMBER
  OUTPUT_ROWS,                             -- OUTPUT_ROWS NUMBER
  LAST_CR_BUFFER_GETS,                     -- LAST_CR_BUFFER_GETS NUMBER
  CR_BUFFER_GETS,                          -- CR_BUFFER_GETS NUMBER
  LAST_CU_BUFFER_GETS,                     -- LAST_CU_BUFFER_GETS NUMBER
  CU_BUFFER_GETS,                          -- CU_BUFFER_GETS NUMBER
  LAST_DISK_READS,                         -- LAST_DISK_READS NUMBER
  DISK_READS,                              -- DISK_READS NUMBER
  LAST_DISK_WRITES,                        -- LAST_DISK_WRITES NUMBER
  DISK_WRITES,                             -- DISK_WRITES NUMBER
  LAST_ELAPSED_TIME,                       -- LAST_ELAPSED_TIME NUMBER
  ELAPSED_TIME,                            -- ELAPSED_TIME NUMBER
  POLICY,                                  -- POLICY VARCHAR2(10)
  ESTIMATED_OPTIMAL_SIZE,                  -- ESTIMATED_OPTIMAL_SIZE NUMBER
  ESTIMATED_ONEPASS_SIZE,                  -- ESTIMATED_ONEPASS_SIZE NUMBER
  LAST_MEMORY_USED,                        -- LAST_MEMORY_USED NUMBER
  LAST_EXECUTION,                          -- LAST_EXECUTION VARCHAR2(10)
  LAST_DEGREE,                             -- LAST_DEGREE NUMBER
  TOTAL_EXECUTIONS,                        -- TOTAL_EXECUTIONS NUMBER
  OPTIMAL_EXECUTIONS,                      -- OPTIMAL_EXECUTIONS NUMBER
  ONEPASS_EXECUTIONS,                      -- ONEPASS_EXECUTIONS NUMBER
  MULTIPASSES_EXECUTIONS,                  -- MULTIPASSES_EXECUTIONS NUMBER
  ACTIVE_TIME,                             -- ACTIVE_TIME NUMBER
  MAX_TEMPSEG_SIZE,                        -- MAX_TEMPSEG_SIZE NUMBER
  LAST_TEMPSEG_SIZE                        -- LAST_TEMPSEG_SIZE NUMBER
from
  GV$SQL_PLAN_STATISTICS_ALL
where
  inst_id = USERENV('Instance')