SELECT 
	file_type, 
	percent_space_used psu,
	percent_space_reclaimable psr, 
	number_of_files nf
FROM 
	v$recovery_area_usage;

FILE_TYPE 				PSU 		PSR 		NF
----------------------- ---------- 	---------- 	----------
CONTROL FILE 					0 			0 			0
REDO LOG 	 					0 			0 			0
ARCHIVED LOG 					0 			0 			1
BACKUP PIECE 				16.57 			0 			4
IMAGE COPY  					0 			0 			0
FLASHBACK LOG 				 3.42 			0 			7
FOREIGN ARCHIVED LOG  			0 			0 			0
AUXILIARY DATAFILE COPY			0 			0 			0