V$SQL_SHARED_MEMORY

Columns
   ___________________________
 
   SUBHEAP_DESC
   CHUNK_TYPE
   ALLOC_CLASS
   CHUNK_SIZE
   CHUNK_PTR
   FUNCTION
   STRUCTURE
   HEAP_DESC
   HASH_VALUE
   SQL_TEXT
   CHUNK_COM

Related Commands: