Flash Recovery Area Usage


SET PAGESIZE 66;
SET LINESIZE 80;

REPHEADER PAGE CENTER ‘Flash Recovery Area Usage’;

COLUMN FILE_TYPE FORMAT a20;
COLUMN FILE_TYPE HEADING ‘File Type’;

COLUMN USED_MB HEADING ‘Used MBytes’;
COLUMN USED_MB FORMAT 9999999999.99;
COLUMN RECLAIMABLE_MB HEADING ‘Reclaimable Mbytes’;
COLUMN RECLAIMABLE_MB FORMAT 99999999999.99;

COLUMN NUMBER_OF_FILES HEADING ‘Number of files’;

BREAK ON REPORT
COMPUTE SUM LABEL ‘Totals:’ OF USED_MB RECLAIMABLE_MB ON REPORT;

SELECT
rau.file_type,
rfd.space_used * rau.percent_space_used / 1024 / 1024 as USED_MB,
rfd.space_reclaimable * rau.percent_space_reclaimable / 1024 / 1024 as RECLAIMABLE_MB,
rau.number_of_files as NUMBER_OF_FILES
FROM
v$recovery_file_dest rfd, v$flash_recovery_area_usage rau;

File Type       Used MBytes       Reclaimable Mbytes        Number of files
——————– ————– —————— —————
CONTROL FILE     .00                      .00                                     0
REDO LOG             .00                       .00                                     0
ARCHIVED LOG     1901.39              .00                                     5
BACKUP PIECE      13114.49               .00                                   1
IMAGE COPY            .00                      .00                                    0
FLASHBACK LOG .  00                       .00                                    0
FOREIGN ARCHIVED LOG .00          .00                                    0
AUXILIARY DATAFILE C .00               .00                                   0
OPY

————– ——————
Totals:                         15015.88           .00

8 rows selected.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s