DBA Data[Home] [Help]

VIEW: SYS.V_$IM_USER_SEGMENTS

Source

View Text - Preformatted

select "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 v$im_user_segments
View Text - HTML Formatted

SELECT "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 V$IM_USER_SEGMENTS