RA_STORAGE_LOCATION_HISTORY

This view contains a daily history of storage location for the for the previous year. It has one row for each storage location for each day going back a year. It may contain phantom rows for storage locations that were deleted.

This data is not expected to be used as-is, but rather as part of GROUP BY classes in order to obtain data such as:

• Average space usage in the storage location per month over the year.
• Minimum or maximum free space goal in the previous year.

Column	Data Type	NULL	Description
SAMPLE_TIME	NUMBER		The day when this storage location history record was created.
NAME	VARCHAR2(128)	NOT NULL	The Recovery Appliance storage location name.
SL_KEY	NUMBER	NOT NULL	The primary key for this Recovery Appliance storage location in the recovery catalog.
TOTAL_SPACE	NUMBER		The maximum amount of storage (in GB) that the Recovery Appliance storage location can use for backup data.
USED_SPACE	NUMBER		The amount of space (in GB) currently used in the Recovery Appliance storage location.
FREESPACE	NUMBER		The amount of space (in GB) available for immediate use.
FREESPACE_GOAL	NUMBER		The expected free space requirement (in GB) based on usage history. Purges may occur to meet this goal.
UNRESERVED_SPACE	NUMBER		The remaining space (in GB) that is available to be assigned to the database disk space reservation.