--   FILE:    recovery_file_dest.sql
--
--   AUTHOR:  Andy Rivenes, arivenes@appsdba.com
--            Copyright (c) 2005, AppsDBA Consulting. All Rights Reserved.
--
--   DATE:    08/25/2005
--
--   DESCRIPTION:
--            This script will list recovery file destination space.
--
--   REQUIREMENTS:
--
--
--   MODIFICATIONS:
--
-- 
-- This program is free software: you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation, either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program.  If not, see <http://www.gnu.org/licenses/>.
-- 
--
SET PAGESIZE 9999;
SET VERIFY off;
SET FEEDBACK off;
SET LINESIZE 132;
--
COLUMN      NAME                  FORMAT A40;
COLUMN      SPACE_LIMIT           FORMAT 999,999,999,999;
COLUMN      SPACE_USED            FORMAT 999,999,999,999;
COLUMN      SPACE_RECLAIMABLE     FORMAT 999,999,999,999;
--
SELECT * 
  FROM v$recovery_file_dest
/