[Home] [Help] [Dependency Information]
Object Name: | INT$DBA_CLUSTERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | |
CLUSTER_NAME | VARCHAR2 | (128) | Yes | |
TABLESPACE_NAME | VARCHAR2 | (30) | Yes | |
PCT_FREE | NUMBER | |||
PCT_USED | NUMBER | |||
KEY_SIZE | NUMBER | |||
INI_TRANS | NUMBER | Yes | ||
MAX_TRANS | NUMBER | Yes | ||
INITIAL_EXTENT | NUMBER | |||
NEXT_EXTENT | NUMBER | |||
MIN_EXTENTS | NUMBER | Yes | ||
MAX_EXTENTS | NUMBER | Yes | ||
PCT_INCREASE | NUMBER | |||
FREELISTS | NUMBER | |||
FREELIST_GROUPS | NUMBER | |||
AVG_BLOCKS_PER_KEY | NUMBER | |||
CLUSTER_TYPE | VARCHAR2 | (5) | ||
FUNCTION | VARCHAR2 | (15) | ||
HASHKEYS | NUMBER | |||
DEGREE | VARCHAR2 | (10) | ||
INSTANCES | VARCHAR2 | (10) | ||
CACHE | VARCHAR2 | (5) | ||
BUFFER_POOL | VARCHAR2 | (7) | ||
FLASH_CACHE | VARCHAR2 | (7) | ||
CELL_FLASH_CACHE | VARCHAR2 | (7) | ||
SINGLE_TABLE | VARCHAR2 | (5) | ||
DEPENDENCIES | VARCHAR2 | (8) | ||
SHARING | NUMBER | |||
ORIGIN_CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CLUSTER_NAME
, TABLESPACE_NAME
, PCT_FREE
, PCT_USED
, KEY_SIZE
, INI_TRANS
, MAX_TRANS
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENTS
, MAX_EXTENTS
, PCT_INCREASE
, FREELISTS
, FREELIST_GROUPS
, AVG_BLOCKS_PER_KEY
, CLUSTER_TYPE
, FUNCTION
, HASHKEYS
, DEGREE
, INSTANCES
, CACHE
, BUFFER_POOL
, FLASH_CACHE
, CELL_FLASH_CACHE
, SINGLE_TABLE
, DEPENDENCIES
, SHARING
, ORIGIN_CON_ID
FROM SYS.INT$DBA_CLUSTERS;
|
|
|