ON CALL DBA SUPPORT

— Database blog

QUERY TO FIND FRA UTILIZATION

Posted by ssgottik on 31/10/2014

set lines 200;
col “Flashback Area” for a40;
SELECT NAME “Flashback Area”, ROUND(SPACE_LIMIT / 1073741824) “Allocated space in GB”, ROUND(SPACE_USED / 1073741824) “Used space in GB”,ROUND(((SPACE_USED /1073741824) * 100) / (SPACE_LIMIT / 1073741824), 2) “USED PERCENTAGE” FROM V$RECOVERY_FILE_DEST where ROUND(((SPACE_USED / 1073741824) * 100) / (SPACE_LIMIT / 1073741824), 2)>0;

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

 
%d bloggers like this: