1、最近由于表空间的不足,因此对表空间增加一个10G的数据文件,命令如下: alter tablespace data_log add datafile '+DATA/pracdb1/datafile/data_log2.ora'size 10240M autoextend off 可在sqlplus中执行上述命令后,一直处于运行状态,等了好久,还是没反应!于是我就把cmd窗口关了!! 2、查询v$datafile后,发现并没有执行成功,于是到alert日志文件中发现下列情况: Wed Mar 25 10:44:34 2009 GES: Potential blocker (pid=4388) on resource TT-0x9-0x8; enqueue info in file c:\oracle\product\10.2.0\admin\pracdb1\udump\pracdb11_ora_4560.trc and DIAG trace file Wed Mar 25 10:58:23 2009 GES: Potential blocker (pid=4560) on resource TT-0x9-0x1; enqueue info in file c:\oracle\product\10.2.0\admin\pracdb1\udump\pracdb11_ora_4388.trc and DIAG trace file Wed Mar 25 13:25:16 2009 GES: Potential blocker (pid=4560) on resource TT-0x9-0x10; enqueue info in file c:\oracle\product\10.2.0\admin\pracdb1\bdump\pracdb11_lmd0_2424.trc and DIAG trace file 3、经得知是由于上述操作造成了死锁(有人说是bug,听到这话吓死人了!!还好不是,呵呵) 通过查询v$lock得知,的确是死锁造成的(这下松口气了!!) 解决方法: alter system kill session 'sid,serial#'; 4、执行上述命令后,查看alert日志文件,如下: Completed: alter tablespace data_log add datafile '+DATA/pracdb1/datafile/data_log2.ora'size 10240M autoextend off
5、再查看v$datafile发现文件已经成功创建了
6、查看表空间的未使用空间有60% 多(未添加前只有10%几)
7、通过几天的观察,一切运行良好!! Thread 1 advanced to log sequence 9730 Current log# 5 seq# 9730 mem# 0: +DATA/pracdb1/onlinelog/redo05_1.log Current log# 5 seq# 9730 mem# 1: +FLASH/pracdb1/onlinelog/flash05_1.ora Thu Mar 26 10:05:03 2009 Thread 1 advanced to log sequence 9731 Current log# 6 seq# 9731 mem# 0: +DATA/pracdb1/onlinelog/redo06_1.log Current log# 6 seq# 9731 mem# 1: +FLASH/pracdb1/onlinelog/flash06_1.ora Thu Mar 26 15:52:18 2009 Thread 1 advanced to log sequence 9732 Current log# 1 seq# 9732 mem# 0: +DATA/pracdb1/onlinelog/redo01_1.log Current log# 1 seq# 9732 mem# 1: +FLASH/pracdb1/onlinelog/flash01_1.ora Fri Mar 27 00:06:37 2009 Thread 1 advanced to log sequence 9733 Current log# 2 seq# 9733 mem# 0: +DATA/pracdb1/onlinelog/redo02_1.log Current log# 2 seq# 9733 mem# 1: +FLASH/pracdb1/onlinelog/flash02_1.ora