select 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 NO_ROOT_SW_FOR_LOCAL(INT$DBA_CLUSTERS)
where OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
SELECT 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 NO_ROOT_SW_FOR_LOCAL(INT$DBA_CLUSTERS)
WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')
|
|
|