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. |