[Home] [Help] [Dependency Information]
Object Name: | DBA_IND_PARTITIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDEX_OWNER | VARCHAR2 | (128) | ||
INDEX_NAME | VARCHAR2 | (128) | ||
COMPOSITE | VARCHAR2 | (3) | ||
PARTITION_NAME | VARCHAR2 | (128) | ||
SUBPARTITION_COUNT | NUMBER | |||
HIGH_VALUE | LONG | (0) | ||
HIGH_VALUE_LENGTH | NUMBER | |||
PARTITION_POSITION | NUMBER | |||
STATUS | VARCHAR2 | (8) | ||
TABLESPACE_NAME | VARCHAR2 | (30) | ||
PCT_FREE | NUMBER | |||
INI_TRANS | NUMBER | |||
MAX_TRANS | NUMBER | |||
INITIAL_EXTENT | NUMBER | |||
NEXT_EXTENT | NUMBER | |||
MIN_EXTENT | NUMBER | |||
MAX_EXTENT | NUMBER | |||
MAX_SIZE | NUMBER | |||
PCT_INCREASE | NUMBER | |||
FREELISTS | NUMBER | |||
FREELIST_GROUPS | NUMBER | |||
LOGGING | VARCHAR2 | (7) | ||
COMPRESSION | VARCHAR2 | (13) | ||
BLEVEL | NUMBER | |||
LEAF_BLOCKS | NUMBER | |||
DISTINCT_KEYS | NUMBER | |||
AVG_LEAF_BLOCKS_PER_KEY | NUMBER | |||
AVG_DATA_BLOCKS_PER_KEY | NUMBER | |||
CLUSTERING_FACTOR | NUMBER | |||
NUM_ROWS | NUMBER | |||
SAMPLE_SIZE | NUMBER | |||
LAST_ANALYZED | DATE | |||
BUFFER_POOL | VARCHAR2 | (7) | ||
FLASH_CACHE | VARCHAR2 | (7) | ||
CELL_FLASH_CACHE | VARCHAR2 | (7) | ||
USER_STATS | VARCHAR2 | (3) | ||
PCT_DIRECT_ACCESS | NUMBER | |||
GLOBAL_STATS | VARCHAR2 | (3) | ||
DOMIDX_OPSTATUS | VARCHAR2 | (6) | ||
PARAMETERS | VARCHAR2 | (1000) | ||
INTERVAL | VARCHAR2 | (3) | ||
SEGMENT_CREATED | VARCHAR2 | (3) | ||
ORPHANED_ENTRIES | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT INDEX_OWNER
, INDEX_NAME
, COMPOSITE
, PARTITION_NAME
, SUBPARTITION_COUNT
, HIGH_VALUE
, HIGH_VALUE_LENGTH
, PARTITION_POSITION
, STATUS
, TABLESPACE_NAME
, PCT_FREE
, INI_TRANS
, MAX_TRANS
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENT
, MAX_EXTENT
, MAX_SIZE
, PCT_INCREASE
, FREELISTS
, FREELIST_GROUPS
, LOGGING
, COMPRESSION
, BLEVEL
, LEAF_BLOCKS
, DISTINCT_KEYS
, AVG_LEAF_BLOCKS_PER_KEY
, AVG_DATA_BLOCKS_PER_KEY
, CLUSTERING_FACTOR
, NUM_ROWS
, SAMPLE_SIZE
, LAST_ANALYZED
, BUFFER_POOL
, FLASH_CACHE
, CELL_FLASH_CACHE
, USER_STATS
, PCT_DIRECT_ACCESS
, GLOBAL_STATS
, DOMIDX_OPSTATUS
, PARAMETERS
, INTERVAL
, SEGMENT_CREATED
, ORPHANED_ENTRIES
FROM SYS.DBA_IND_PARTITIONS;
|
|
|