eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$IM_HEADER

Object Details

Object Name:	V_$IM_HEADER
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
OBJD	NUMBER
TSN	NUMBER
IMCU_ADDR	RAW	(8)
ALLOCATED_LEN	NUMBER
USED_LEN	NUMBER
IS_HEAD_PIECE	NUMBER
PREPOPULATED	NUMBER
REPOPULATED	NUMBER
TRICKLE_REPOPULATED	NUMBER
ADDITIONAL_IMCU_PIECES	NUMBER
HEAD_PIECE_ADDRESS	RAW	(8)
NEXT_PIECE_ADDRESS	RAW	(8)
COMPRESSION_LEVEL	NUMBER
NUM_DISK_EXTENTS	NUMBER
NUM_TARGET_ROWS	NUMBER
NUM_TARGET_BLOCKS	NUMBER
HEADER_SIZE	NUMBER
NUM_COLS	NUMBER
NUM_ROWS	NUMBER
NUM_BLOCKS	NUMBER
CON_ID	NUMBER
TIME_TO_POPULATE	NUMBER
TIMESTAMP	TIMESTAMP(6) WITH TIME ZONE	(20)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJD
,      TSN
,      IMCU_ADDR
,      ALLOCATED_LEN
,      USED_LEN
,      IS_HEAD_PIECE
,      PREPOPULATED
,      REPOPULATED
,      TRICKLE_REPOPULATED
,      ADDITIONAL_IMCU_PIECES
,      HEAD_PIECE_ADDRESS
,      NEXT_PIECE_ADDRESS
,      COMPRESSION_LEVEL
,      NUM_DISK_EXTENTS
,      NUM_TARGET_ROWS
,      NUM_TARGET_BLOCKS
,      HEADER_SIZE
,      NUM_COLS
,      NUM_ROWS
,      NUM_BLOCKS
,      CON_ID
,      TIME_TO_POPULATE
,      TIMESTAMP
FROM SYS.V_$IM_HEADER;

Dependencies

[top of page]

SYS.V_$IM_HEADER references the following:

SYS.V_$IM_HEADER is referenced by following:

PUBLIC: V$IM_HEADER