oracle表空间管理

/*查看各表空间分配情况*/
select tablespace_name, sum(bytes) / 1024 / 1024
  from dba_data_files
 group by tablespace_name;


/*查看各表空间空闲情况*/
select tablespace_name, sum(bytes) / 1024 / 1024
  from dba_free_space
 group by tablespace_name;
;

/*查看表空间是否自动增长*/
SELECT FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE FROM dba_data_files;

/*更改数据表大小(10G)*/
alter database datafile '/ora/oradata/radius/undo.dbf' resize 10240m；

/*查看表空间是否自动扩展*/
SELECT FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE FROM dba_data_files;

/*每次自动增长200m*/
ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\PMS01.DBF' AUTOEXTEND ON NEXT 100M ;

/*每次自动增长200m，数据表最大不超过1G*/
ALTER DATABASE DATAFILE 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\PMS01.DBF' AUTOEXTEND ON NEXT 200M MAXSIZE 1024M;