DBA Data[Home] [Help]

VIEW: SYS.DBA_CLUSTERS

Source

View Text - Preformatted

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
from INT$DBA_CLUSTERS
View Text - HTML Formatted

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 FROM INT$DBA_CLUSTERS