Oracle tablespace utilization and object size Query

1. Check the size of all tablespaces SQLgt; selecttablespace_name, sum (bytes) 10241024Mfromdba_data_filesgroupbytablespace_name

1. View All tablespaces SQLgt; select tablespace_name, sum (bytes)/1024/1024 M from dba_data_files group by tablespace_name

1. view the size of all tablespaces

SQL> select tablespace_name, sum (bytes)/1024/1024 M from dba_data_files group by tablespace_name;

2. Used tablespace size
SQL> select tablespace_name, sum (bytes)/1024/1024 M from dba_free_space group by tablespace_name;

3. Therefore, space can be calculated in this way.

Select a. tablespace_name, total, free, total-free used from
(Select tablespace_name, sum (bytes)/1024/1024 total from dba_data_files
Group by tablespace_name),
(Select tablespace_name, sum (bytes)/1024/1024 free from dba_free_space
Group by tablespace_name) B
Where a. tablespace_name = B. tablespace_name;

4. The following statement shows the size of all segments.
Select Segment_Name, Sum (bytes)/1024/1024 From User_Extents Group By Segment_Name

5. How to put the result into a file in the case of command line.
SQL> spool out.txt
SQL> select * from v $ database;
SQL> spool off

For more information about Oracle, see the Oracle topic page? Tid = 12

,