远程链接客户那边的Oracle主机，扩展主要表空间的大小

SELECT 
a.tablespace_name 表空间名称, 
total 总计, 
total - free 已使用, 
free 空闲, 
round((total - free) / total * 100, 2) 使用占比
FROM (
SELECT tablespace_name
, round(SUM(bytes) / 1024 / 1024) AS total
FROM dba_data_files
GROUP BY tablespace_name
) a
LEFT JOIN (
SELECT tablespace_name
, round(SUM(bytes) / 1024 / 1024) AS free
FROM dba_free_space
GROUP BY tablespace_name
) b
ON a.tablespace_name = b.tablespace_name
ORDER BY (total - free) / total DESC;

ALTER DATABASE DATAFILE ‘/data/oracle/oradata/cdmsmdb/cdmsdata.dbf‘ AUTOEXTEND ON NEXT 500M MAXSIZE 20480M;
 
ALTER DATABASE DATAFILE ‘/data/oracle/oradata/cdmsmdb/system01.dbf‘ AUTOEXTEND ON NEXT 500M MAXSIZE 20480M; 

ALTER TABLESPACE app_data ADD DATAFILE ’/data/oracle/oradata/cdmsmdb/cdmsdata.dbf‘ SIZE 20480M;