UPDATE_STORAGE_LOCATION

This procedure allocates additional space for the specified storage location. You cannot reduce the amount of space used by a storage location.

Syntax

PROCEDURE update_storage_location (
   storage_location_name IN VARCHAR2,
   comments IN VARCHAR2 DEFAULT NULL,
   autotune_space_limit IN VARCHAR2 DEFAULT dbms_ra_misc.varchar2null('pl'));

Parameters

Table 22-61 UPDATE_STORAGE_LOCATION Parameters

Parameter Description

storage_location_name

The name of the storage location to update.

comments

Optional user supplied comment describing reason for executing this command.

autotune_space_limit

Autotune will not limit reserved space growth when the total reserved space usage is below this limit. When the total reserved space usage is above this limit, autotune will limit subsequent reserved space growth to 10% per week for each database in the storage location.

The format of this value is a character string that must contain a number consisting only of the characters 0-9, followed optionally by one of the following unit specifiers:

  • K: Kilobytes
  • M: Megabytes
  • G: Gigabytes
  • T: Terabytes

If no unit is specified, then Recovery Appliance interprets the value as a number of bytes. This value may be set to NULL if there should never be restrictions on reserved space growth through the autotune_reserved_space option.