select "INST_ID","SQL_TEXT","SQL_FULLTEXT","HASH_VALUE","SQL_ID","HEAP_DESC","STRUCTURE","FUNCTION","CHUNK_COM","CHUNK_PTR","CHUNK_SIZE","ALLOC_CLASS","CHUNK_TYPE","SUBHEAP_DESC","CON_ID" from gv$sql_shared_memory
SELECT "INST_ID"
, "SQL_TEXT"
, "SQL_FULLTEXT"
, "HASH_VALUE"
, "SQL_ID"
, "HEAP_DESC"
, "STRUCTURE"
, "FUNCTION"
, "CHUNK_COM"
, "CHUNK_PTR"
, "CHUNK_SIZE"
, "ALLOC_CLASS"
, "CHUNK_TYPE"
, "SUBHEAP_DESC"
, "CON_ID"
FROM GV$SQL_SHARED_MEMORY
|
|
|