查看表空间信息:
SELECT A.TABLESPACE_NAME,
A.TOTAL_MB,
ROUND(B.FREE_MB, 2) FREE_MB,
TO_CHAR(ROUND((A.TOTAL_MB - B.FREE_MB) / A.TOTAL_MB * 100, 2), '990.99') || '%' "USAGE %"
FROM (SELECT TABLESPACE_NAME, SUM(BYTES) / 1024 / 1024 TOTAL_MB
FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) A,
(SELECT TABLESPACE_NAME, SUM(BYTES) / 1024 / 1024 FREE_MB
FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) B,
DBA_TABLESPACES D
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME(+)
AND A.TABLESPACE_NAME = D.TABLESPACE_NAME(+)
ORDER BY 4 DESC;
表空间扩容:
--表空间扩容有两种方式,一种是给本来的数据文件扩容,另一种是给表空间增加数据文件
ALTER TABLESPACE <TABLESPACE_NAME> ADD DATAFILE 'XXX.DBF' SIZE 10240 ;
ALTER TABLESPACE <TABLESPACE_NAME> RESIZE DATAFILE 'XXX.DBF' TO 10240;
查询数据库会话、句柄
SELECT '活动