[Home] [Help] [Dependency Information]
Object Name: | V_$IM_SEGMENTS_DETAIL |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TSN | NUMBER | |||
RELFILE | NUMBER | |||
BLOCK_ID | NUMBER | |||
DATAOBJ | NUMBER | |||
OBJ | NUMBER | |||
BASEOBJ | NUMBER | |||
INC | NUMBER | |||
SPARE_ID | NUMBER | |||
SEGTYPE | NUMBER | |||
DISTDIM | VARCHAR2 | (30) | ||
MEMADDR | NUMBER | |||
MEMEXTENTS | NUMBER | |||
MEMBYTES | NUMBER | |||
EXTENTS | NUMBER | |||
BLOCKS | NUMBER | |||
DATABLOCKS | NUMBER | |||
BLOCKSINMEM | NUMBER | |||
BYTES | NUMBER | |||
CREATETIME | TIMESTAMP(6) | (20) | ||
STATUS | NUMBER | |||
POPULATE_STATUS | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TSN
, RELFILE
, BLOCK_ID
, DATAOBJ
, OBJ
, BASEOBJ
, INC
, SPARE_ID
, SEGTYPE
, DISTDIM
, MEMADDR
, MEMEXTENTS
, MEMBYTES
, EXTENTS
, BLOCKS
, DATABLOCKS
, BLOCKSINMEM
, BYTES
, CREATETIME
, STATUS
, POPULATE_STATUS
, CON_ID
FROM SYS.V_$IM_SEGMENTS_DETAIL;
|
|
|