[Home] [Help] [Dependency Information]
Object Name: | GV_$IM_SEGMENTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
OWNER | VARCHAR2 | (128) | ||
SEGMENT_NAME | VARCHAR2 | (128) | ||
PARTITION_NAME | VARCHAR2 | (128) | ||
SEGMENT_TYPE | VARCHAR2 | (18) | ||
TABLESPACE_NAME | VARCHAR2 | (30) | ||
INMEMORY_SIZE | NUMBER | |||
BYTES | NUMBER | |||
BYTES_NOT_POPULATED | NUMBER | |||
POPULATE_STATUS | VARCHAR2 | (9) | ||
INMEMORY_PRIORITY | VARCHAR2 | (8) | ||
INMEMORY_DISTRIBUTE | VARCHAR2 | (15) | ||
INMEMORY_DUPLICATE | VARCHAR2 | (13) | ||
INMEMORY_COMPRESSION | VARCHAR2 | (17) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
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 SYS.GV_$IM_SEGMENTS;
|
|
|