Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

MAP_OBJECT

MAP_OBJECT is a global temporary table that displays the hierarchical arrangement of storage containers for objects. Each row in the table represents a level in the hierarchy.

Column Datatype NULL Description
OBJECT_NAME VARCHAR2(2000)   Name of the object
OBJECT_OWNER VARCHAR2(2000)   Owner of the object
OBJECT_TYPE VARCHAR2(2000)   Object type
FILE_MAP_IDX NUMBER   File index (corresponds to FILE_MAP_IDX in V$MAP_FILE)
DEPTH NUMBER   Element depth within the I/O stack
ELEM_IDX NUMBER   Index corresponding to the element
CU_SIZE NUMBER   Contiguous set of logical blocks of the file (in HKB units) that is resident contiguously on the element
STRIDE NUMBER   Number of HKB between contiguous units (CU) in the file that are contiguous on this element. Used in RAID5 and striped files.
NUM_CU NUMBER   Number of contiguous units that are adjacent to each other on this element that are separated by STRIDE HKB in the file. In RAID5, the number of contiguous units also include the parity stripes.
ELEM_OFFSET NUMBER   Element offset (in HKB units)
FILE_OFFSET NUMBER   Offset (in HKB units) from the start of the file to the first byte of the contiguous units
DATA_TYPE VARCHAR2(2000)   Datatype (DATA, PARITY, or DATA AND PARITY)
PARITY_POS NUMBER   Position of the parity. Only for RAID5. This field is needed to distinguish the parity from the data part.
PARITY_PERIOD NUMBER   Parity period. Only for RAID5.