select
  KEY,                                     -- KEY NUMBER
  STATUS,                                  -- STATUS VARCHAR2(19)
  FIRST_REFRESH_TIME,                      -- FIRST_REFRESH_TIME DATE
  LAST_REFRESH_TIME,                       -- LAST_REFRESH_TIME DATE
  FIRST_CHANGE_TIME,                       -- FIRST_CHANGE_TIME DATE
  LAST_CHANGE_TIME,                        -- LAST_CHANGE_TIME DATE
  REFRESH_COUNT,                           -- REFRESH_COUNT NUMBER
  SID,                                     -- SID NUMBER
  PROCESS_NAME,                            -- PROCESS_NAME VARCHAR2(5)
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  SQL_EXEC_START,                          -- SQL_EXEC_START DATE
  SQL_EXEC_ID,                             -- SQL_EXEC_ID NUMBER
  SQL_PLAN_HASH_VALUE,                     -- SQL_PLAN_HASH_VALUE NUMBER
  SQL_CHILD_ADDRESS,                       -- SQL_CHILD_ADDRESS RAW(8)
  PLAN_PARENT_ID,                          -- PLAN_PARENT_ID NUMBER
  PLAN_LINE_ID,                            -- PLAN_LINE_ID NUMBER
  PLAN_OPERATION,                          -- PLAN_OPERATION VARCHAR2(30)
  PLAN_OPTIONS,                            -- PLAN_OPTIONS VARCHAR2(30)
  PLAN_OBJECT_OWNER,                       -- PLAN_OBJECT_OWNER VARCHAR2(30)
  PLAN_OBJECT_NAME,                        -- PLAN_OBJECT_NAME VARCHAR2(30)
  PLAN_OBJECT_TYPE,                        -- PLAN_OBJECT_TYPE VARCHAR2(20)
  PLAN_DEPTH,                              -- PLAN_DEPTH NUMBER
  PLAN_POSITION,                           -- PLAN_POSITION NUMBER
  PLAN_COST,                               -- PLAN_COST NUMBER
  PLAN_CARDINALITY,                        -- PLAN_CARDINALITY NUMBER
  PLAN_BYTES,                              -- PLAN_BYTES NUMBER
  PLAN_TIME,                               -- PLAN_TIME NUMBER
  PLAN_PARTITION_START,                    -- PLAN_PARTITION_START VARCHAR2(64)
  PLAN_PARTITION_STOP,                     -- PLAN_PARTITION_STOP VARCHAR2(64)
  PLAN_CPU_COST,                           -- PLAN_CPU_COST NUMBER
  PLAN_IO_COST,                            -- PLAN_IO_COST NUMBER
  PLAN_TEMP_SPACE,                         -- PLAN_TEMP_SPACE NUMBER
  STARTS,                                  -- STARTS NUMBER
  OUTPUT_ROWS,                             -- OUTPUT_ROWS NUMBER
  IO_INTERCONNECT_BYTES,                   -- IO_INTERCONNECT_BYTES NUMBER
  PHYSICAL_READ_REQUESTS,                  -- PHYSICAL_READ_REQUESTS NUMBER
  PHYSICAL_READ_BYTES,                     -- PHYSICAL_READ_BYTES NUMBER
  PHYSICAL_WRITE_REQUESTS,                 -- PHYSICAL_WRITE_REQUESTS NUMBER
  PHYSICAL_WRITE_BYTES,                    -- PHYSICAL_WRITE_BYTES NUMBER
  WORKAREA_MEM,                            -- WORKAREA_MEM NUMBER
  WORKAREA_MAX_MEM,                        -- WORKAREA_MAX_MEM NUMBER
  WORKAREA_TEMPSEG,                        -- WORKAREA_TEMPSEG NUMBER
  WORKAREA_MAX_TEMPSEG                     -- WORKAREA_MAX_TEMPSEG NUMBER
from
  GV$SQL_PLAN_MONITOR
where
  inst_id=USERENV('Instance')