ESTIMATE_SPACE

This procedure estimates the amount of storage in GB required for recovery of a given database and a desired recovery window. It requires a database name and a desired recovery window.

If the database is in an unregistered state or if there are no backups for the database, estimate_space returns NULL or no value.

Syntax

FUNCTION estimate_space (
   db_unique_name IN VARCHAR2,
   target_window IN DSINTERVAL_UNCONSTRAINED,
   comments IN VARCHAR2 DEFAULT NULL)
RETURN NUMBER;

Parameters

Table 22-25 ESTIMATE_SPACE Parameters

Parameter	Description
`db_unique_name`	The name of the database needing the storage estimate.
`target_window`	The desired recovery window for the database. Specify the goal as any valid `INTERVAL DAY TO SECOND` expression, such as `INTERVAL '2' DAY` (2 days), `INTERVAL '4' HOUR` (4 hours), and so on.
`comments`	Optional user supplied comment describing reason for executing this command.
`RETURNS`	Gigabytes of space needed to achieve recoverability across the `target_window`.