表空间大小,路径
col tname format a20
col dname format a60
select t.name as tname, d.name dname, d.bytes/1024/1024/1024 GB
from v$tablespace t join v$datafile d using(ts#)
where t.name like &tablespace_name;状态,数据文件
col fi…
Tablespace free space can be viewed in V$TABLESPACE ✖
Tablespace free space can be viewed in DBA_TABLESPACES ✖
tbs.sql
--表空间使用率
set linesize 220 pagesize 10000
COL SIZE_G FOR A15
COL FREE_G FOR A15
COL USED_PCT FOR A10
COL TABLESPACE_NAME FOR …