How to Check the tablespace size in oracle Database ?

  The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage.

Summary: in this tutorial, you will learn how to Find the Tablespace size in the oracle database,

Kindly Fire the below command to find the tablespace size.

col tablespace_name for a40 

select b.tablespace_name, b.total "Mb Total", sum( a.bytes/(1024 * 1024)) "Mb Free", sum( a.bytes/(1024 * 1024))/b.total*100 "%Free" from dba_free_space a, (select tablespace_name, sum(bytes/1024/1024) total from dba_data_files group by tablespace_name) b where a.tablespace_name(+)=b.tablespace_name group by b.tablespace_name, b.total order by 4;

Output:

To find the individual tablespace commands.

select file_name, bytes/(1024 * 1024), autoextensible, MAXBYTES/(1024 * 1024) from 

dba_data_files where tablespace_name=upper('&tname');

Output:

                                                        Thanks for your time!!