Oracle查询表空间大小

Oracle查询表空间大小

– 表空间基础信息
select * from Dba_Tablespaces;
select TABLESPACE_NAME from Dba_Tablespaces;

– 常规表空间大小
SELECT
file_name,
tablespace_name,
( bytes / 1024 / 1024 ) bytes_M,
autoextensible,
( maxbytes / 1024 / 1024 ) maxbytes_M,
( user_bytes / 1024 / 1024 ) user_bytes_M
FROM
dba_data_files;

– 临时表空间大小
SELECT
file_name,
tablespace_name,
( bytes / 1024 / 1024 ) bytes_M,
autoextensible,
( maxbytes / 1024 / 1024 ) maxbytes_M,
( user_bytes / 1024 / 1024 ) user_bytes_M
FROM
dba_temp_files;