1)查看各表空间分配情况
SQL>selecttablespace_name,sum(bytes)/1024/1024fromdba_data_filesgroupbytablespace_name;
TABLESPACE_NAMESUM(BYTES)/1024/1024
--------------------------------------------------
UNDOTBS1100
SYSAUX530
USERS5
SYSTEM700
EXAMPLE100
5rowsselected
2)查看各表空间空闲情况
SQL>selecttablespace_name,sum(bytes)/1024/1024fromdba_free_spacegroupbytablespace_name;
TABLESPACE_NAMESUM(BYTES)/1024/1024
--------------------------------------------------
SYSAUX26.125
UNDOTBS169.6875
USERS0.9375
SYSTEM1.1875
EXAMPLE21.25
5rowsselected
3)更改数据表大小(10G)
代码如下:
alterdatabasedatafile'/ora/oradata/radius/testNS.dbf'resize10240m;
|