15:28:05 jlanzpa817>desc dba_free_space; 名称 空? 类型 ----------------------------------------- -------- ------------- TABLESPACE_NAME VARCHAR2(30) FILE_ID NUMBER BLOCK_ID NUMBER BYTES NUMBER BLOCKS NUMBER RELATIVE_FNO NUMBER
select tablespace_name, sum(bytes) free from dba_free_space group by tablespace_name; select * from v$datafiel; select * from dba_data_files;
像TOAD可以看的真真切切,
pl/sql developer有这样的报表,
object brower有更形像的界面。
在8.1.7 的
DBA studio里面也可以看到阿
名称 空? 类型
----------------------------------------- -------- -------------
TABLESPACE_NAME VARCHAR2(30)
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
select * from v$datafiel;
select * from dba_data_files;