# 44663
duncan2008
来自: 深圳
|
|
To: eygle
大师:
同样的RAC平台2数据库大小为7G,/arch1,/arch2目录下归档没有,很正常
RAC平台3平台归档量很大,很不正常,找不到原因?
SQL> Select Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tabl
espace_Name;
TABLESPACE_NAMESUM(BYTES)/1024/1024
GMMS_DATA 14865.375
GMMS_INDEX2146.0625
UNDOTBS1 1184.78125
/arch1:
rw-r----- 1 oracle dba 3274240 Sep 16 12:50 1_15945.dbf
rw-r----- 1 oracle dba13051392 Sep 16 14:06 1_15946.dbf
rw-r----- 1 oracle dba19255296 Sep 16 15:23 1_15947.dbf
/arch2:
--rw-r----- 1 oracle dba 524287488 Sep 16 14:12 2_6778.dbf
-rw-r----- 1 oracle dba 524287488 Sep 16 14:39 2_6779.dbf
-rw-r----- 1 oracle dba 524287488 Sep 16 15:03 2_6780.dbf
-rw-r----- 1 oracle dba 524287488 Sep 16 15:25 2_6781.dbf
From: duncan2008 2010.09.16 00:33
|
|
|
|
To: duncan2008
用Logmnr解析一下就知道是什么内容了。
From: eygle 2010.09.16 02:48
|
|
|
|