select "INST_ID","OWNER","SEGMENT_NAME","PARTITION_NAME","SEGMENT_TYPE","TABLESPACE_NAME","INMEMORY_SIZE","BYTES","BYTES_NOT_POPULATED","POPULATE_STATUS","INMEMORY_PRIORITY","INMEMORY_DISTRIBUTE","INMEMORY_DUPLICATE","INMEMORY_COMPRESSION","CON_ID" from gv$im_segments
SELECT "INST_ID"
, "OWNER"
, "SEGMENT_NAME"
, "PARTITION_NAME"
, "SEGMENT_TYPE"
, "TABLESPACE_NAME"
, "INMEMORY_SIZE"
, "BYTES"
, "BYTES_NOT_POPULATED"
, "POPULATE_STATUS"
, "INMEMORY_PRIORITY"
, "INMEMORY_DISTRIBUTE"
, "INMEMORY_DUPLICATE"
, "INMEMORY_COMPRESSION"
, "CON_ID"
FROM GV$IM_SEGMENTS
|
|
|