linux查看mysql表空间使用率_Oracle 查询表空间使用情况

通过查询dba_free_space表可以了解一个tablespace的空间使用情况。

TABLESPACE_NAME：

Name of the tablespace containing the extent

FILE_ID：

ID number of the file containing the extent

BLOCK_ID：

Starting block number of the extent

BYTES：

Size of the extent in bytes

BLOCKS：

Size of the extent in ORACLE block

1。查询表空间的free space

SQL> select

2 tablespace_name,

3 count(*) as extends,

4 round(sum(bytes)/1024/1024, 2) as MB,

5 sum(blocks) as blocks

6 from dba_free_space group by tablespace_name;

TABLESPACE EXTENDS MB BLOCKS

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

UNDOTBS1 16 771.69 49388

SYSAUX 46 8.44 540

BLOBS 375 805.63 51560

USERS 645 67.69 4332

SYSTEM 1 4.75 304

INDX 1871 1071.56 68580

WCAUDIT 1 499.94 31996