Statistics on Oracle tablespace

Every time the server administrator notifies that a file occupies too much hard disk space, it is estimated that the tablespace of the Oracle database has become larger. There is no way. You need to be aware of the number of tablespaces currently occupied. Therefore, we will summarize several common table space statistics methods, but they are not very comprehensive. We will continue to sort out the updates in future work.

1. Statistics on the size of each tablespace:

Select Tablespace_Name, Sum (bytes)/1024/1024 From Dba_Segments Group By Tablespace_Name

2. Total statistics of all tablespaces:

Select B. name, sum (. bytes/1000000) total space from v $ datafile a, v $ tablespace B where. ts # = B. ts # group by B. name;

3. view the remaining tablespace:

SELECT tablespace_name tablespace, sum (blocks * 8192/1000000) residual space m from dba_free_space group by tablespace_name;

Oracle Undo image data exploration

Oracle ROLLBACK and Undo)

The Undo tablespace cannot be opened because it is damaged.

How to handle Undo tablespace failures

Oracle Undo tablespace reconstruction and restoration