oracle查看剩余表空间
时间: 2023-09-03 07:14:58 浏览: 49
你可以使用以下SQL语句查看Oracle数据库中的剩余表空间:
```
SELECT tablespace_name, SUM(bytes)/1024/1024 AS "Total Size (MB)", SUM(bytes-free_bytes)/1024/1024 AS "Used Size (MB)", SUM(free_bytes)/1024/1024 AS "Free Size (MB)"
FROM (SELECT tablespace_name, bytes, SUM(CASE WHEN block_id + blocks = next_block_id THEN 0 ELSE next_block_id - block_id END * block_size) AS free_bytes
FROM (SELECT tablespace_name, file_id, block_id, blocks, block_size, LEAD(block_id) OVER (PARTITION BY tablespace_name, file_id ORDER BY block_id) AS next_block_id
FROM dba_extents)
GROUP BY tablespace_name, bytes)
GROUP BY tablespace_name;
```
这条SQL语句将返回每个表空间的名称、总大小、已用空间和剩余空间。你可以在Oracle SQL Developer或SQL Plus等工具中运行此SQL语句。