Everyday Common SQL

DB Size / Tablespace Size / Tablespace Usage -- DB Size, database size free and % used ----------------------------------------- col TABLESPACE_NAME for a30 col NoDbf for a5 select NoDbf, round(tbs.size_tbs, 0) "Size(MB)" , round(nvl(df.size_free, 0), 0) "Free Space(MB)", round((tbs.size_tbs - nvl(df.size_free, 0))/tbs.size_tbs*100, 0) "% Used" from (select sum(bytes)/1024/1024 size_tbs, count(*)||'' NoDbf from dba_data_files ) tbs, (select sum(bytes)/1024/1024 size_free from dba_free_space ) df;