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.ALL_IND_PARTITIONS

Object Details

Object Name:	ALL_IND_PARTITIONS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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)

Query Text

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.ALL_IND_PARTITIONS;

Dependencies

[top of page]

SYS.ALL_IND_PARTITIONS references the following:

SYS: DEFERRED_STG$; IND$; INDCOMPART$; INDPART$; INDPART_PARAM$; OBJ$; OBJAUTH$; SEG$; TAB$; TS$; USER$

SYS.ALL_IND_PARTITIONS is referenced by following:

PUBLIC: ALL_IND_PARTITIONS
SYS: DBMS_COMPARISON - show dependent code; DBMS_ISYNCREF - show dependent code; PRVT_COMPRESSION - show dependent code