环境: os:red hat enterprise linux as release 4 (nahant) db:oracle database 10g enterprise edition release 10.2.0.1.0 - production 一台oracle10gr2数据库报出如下错误: ora-1653: unable to extend table sysman.mgmt_system_error_log by 8 in tablespace sysaux ora-1653: unable to extend table sysman.mgmt_system_error_log by 8 in tablespace sysaux ora-1653: unable to extend table sysman.mgmt_system_error_log by 8 in tablespace sysaux ora-1653: unable to extend table sysman.mgmt_system_error_log by 8 in tablespace sysaux ora-1653: unable to extend table sysman.mgmt_system_error_log by 8 in tablespace sysaux
登陆检查，发现是sysaux表空间空间用尽,不能扩展,尝试手工扩展sysaux表空间: alter database datafile ’ oradg/danaly/datafile/sysaux.266.600173881’ resize 800m tue nov 29 23:31:38 2005 ora-1237 signalled during: alter database datafile ’ oradg/danaly/datafile/sysaux.266.600173881’ resize 800m...
出现ora-1237错误，提示空间不足。这时候我才认识到是磁盘空间可能被用完了.
是谁"偷偷的"用了那么多空间呢(本来有几十个g的free磁盘空间的)? 检查数据库表空间占用空间情况: sql> 0select tablespace_name,sum(bytes)/1024/1024/1024 gb 2 from dba_data_files group by tablespace_name 3 union all 4 0select tablespace_name,sum(bytes)/1024/1024/1024 gb 5 from dba_temp_files group by tablespace_name order by gb. tablespace_name gb ------------------------------ ---------- users .004882813 undotbs2 .09765625 system .478515625 sysaux .634765625 wapcm_ts_visit_detail .9765625 hy_ds_default 1 mint_ts_default 1 mms_ts_data2 1.375 mms_idx_sjh 2 mms_ts_default 2 ivrcn_ts_data 2