Change the storage properties of a cluster.
Syntax:
ALTER CLUSTER schema.cluster options
The options used with this command can be any combination of the following:
PCTUSED int
PCTFREE int
INITRANS int
MAXTRANS int
SIZE int K | M
TABLESPACE tablespace_name
STORAGE storage_clause
CACHE int | NOCACHE
ALLOCATE EXTENT
ALLOCATE EXTENT SIZE int K | M
ALLOCATE EXTENT DATAFILE 'filename'
ALLOCATE EXTENT INSTANCE int
DEALLOCATE UNUSED
DEALLOCATE UNUSED KEEP int K | M
INSTANCE instance_no
PARALLEL parallel_clause
If the PARALLEL clause is used it should be the last option.
Specify CACHE if you want the blocks retrieved for this cluster to be placed at the most recently used end of the least recently used (LRU) list in the buffer cache when a full table scan is performed. This can improve performance for small lookup tables.
When you explicitly ALLOCATE an extent, Oracle will ignore the cluster’s storage parameters when allocating space for a new extent. Therefore, specify SIZE only if you do not want to use the default value.
“Birds of a feather will gather together” ~ Robert Burton
Related Oracle Commands:
ANALYZE CLUSTER COMPUTE STATISTICS
CREATE CLUSTER
Related Views:
DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS DBA_DATA_FILES