²éѯOracleµÄËùÓбí¿Õ¼ä

ÎÒÓÐOracleµÄȨÏÞ£¬ÏëÖªµÀÔõÑù²éѯÆäÖеÄËùÓбí¿Õ¼ä
ÊÇsqlplusµÄ£¬Ã»ÓпÉÊÓ»¯µÄ´°¿Ú

---

SQL code:
SELECT tablespace_name,file_name from dba_data_files;

---

select * from dba_tablespaces

---

SQL> select name from v$tablespace;

NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE

6 rows selected.

---

2,3¶¼¿ÉÒÔi

---

ÒýÓÃ

SQL> select name from v$tablespace;

NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
USERS
TEMP
EXAMPLE

6 rows selected.

¶¥

---

¶÷£¬2.3Â¥¶¼¿ÉÒÔ²é³öÀ´£¡

---

select * from dba_tablespace;

---

·¹ýÁôÓ¡

---

select * from dba_tablespaces

---

´Õ¸öÈÈÄÖ..

SELECT F.TABLESPACE_NAME,
TO_CHAR ((T.TOTAL_SPACE - F.FREE_SPACE),'999,999') "USED (MB)",
TO_CHAR (F.FREE_SPACE, '999,999') "FREE (MB)",
TO_CHAR (T.TOTAL_SPACE, '999,999') "TOTAL (MB)",
TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),'999')||' %' PER_FREE
from (
SELECT TABLESPACE_NAME,
ROUND (SUM (BLOCKS*(SELECT VALUE/1024
from V\$PARAMETER