ALTER CLUSTER

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 may 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 Commands:

ANALYZE CLUSTER COMPUTE STATISTICS
CREATE CLUSTER

Related Views:

 DBA_CLUSTERS      ALL_CLUSTERS     USER_CLUSTERS 
 DBA_DATA_FILES 


© Copyright SS64.com 1999-2014
Some rights reserved