create table size_before_patch as
select d.tablespace_name, d.file_id, d.file_name, d.bytes/1024/1024 allocated, 
nvl(f.bytes,0)/1024/1024 free 
from (select tablespace_name, file_id, file_name, sum(bytes) bytes 
from dba_data_files
group by tablespace_name, file_id, file_name) d, 
(select tablespace_name, file_id, sum(bytes) bytes 
from dba_free_space 
group by tablespace_name, file_id) f 
where d.tablespace_name = f.tablespace_name(+) and d.file_id = f.file_id(+) 
order by tablespace_name, file_name;


Similarly i created table size_after_patch after executing the patch

select sum(allocated)/1024,sum(free)/1024 from size_before_patch
SUM(ALLOCATED)/1024	SUM(FREE)/1024
[B]491[/B].254791259766	[B]61[/B].3338012695313


select sum(allocated)/1024,sum(free)/1024 from size_after_patch
SUM(ALLOCATED)/1024	SUM(FREE)/1024
[B]507[/B].254791259766	[B]50[/B].6898803710938