select
  SQL_TEXT,                                -- SQL_TEXT VARCHAR2(1000)
  SQL_FULLTEXT,                            -- SQL_FULLTEXT CLOB
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  HEAP_DESC,                               -- HEAP_DESC RAW(8)
  STRUCTURE,                               -- STRUCTURE VARCHAR2(16)
  FUNCTION,                                -- FUNCTION VARCHAR2(16)
  CHUNK_COM,                               -- CHUNK_COM VARCHAR2(16)
  CHUNK_PTR,                               -- CHUNK_PTR RAW(8)
  CHUNK_SIZE,                              -- CHUNK_SIZE NUMBER
  ALLOC_CLASS,                             -- ALLOC_CLASS VARCHAR2(8)
  CHUNK_TYPE,                              -- CHUNK_TYPE NUMBER
  SUBHEAP_DESC                             -- SUBHEAP_DESC RAW(8)
from
  GV$SQL_SHARED_MEMORY
where
  inst_id = USERENV('Instance')