Free Space per tablespace....

Jeeeeeeeeeee this is going into my head now. Please help..... Cannot find my script and too bad that I am making mistakes in rebuiding....

I want to find out Space in Tablespace and Free Space. I have two simplest of individual queries.

Group by in first query helps grouping for each datafie in the tablespace

Group by in second helps grouping free chunks in the tablespace

column tablespace_name format a30
column tot_size format 9,999,999.90
column fr_size format 9,999,999.90

select tablespace_name, sum(bytes)/1048576 tot_size from dba_data_files
group by tablespace_name
order by tot_size;

select tablespace_name, sum(bytes)/1048576 fr_size from dba_free_space
group by tablespace_name
order by fr_size;

Output should be...

TABLESPACE_NAME TOT_SIZE FR_SIZE

------------------------ ------------ ---------------