0 积分	1 好友	7 主题

发消息

[SQL调优] 数据库归档特别频繁

1^#

发表于 2013-7-9 15:24:09 | 查看: 2895| 回复: 4

9i的数据库，发现归档特别频繁，归档大小一会就增长了3个G了，还有一点不懂，为什么归档文件大小不一样，有的200m，有的才1k。

$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jul 9 15:02:12 2013

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining op
tions
JServer Release 9.2.0.1.0 - Production

SQL> select inst_id,host_name from gv$instance;

INST_ID HOST_NAME
---------- ----------------------------------------------------------------
      1 HZga550A

SQL> select member from v$logfile
  2  ;

MEMBER
--------------------------------------------------------------------------------
/dev/rrk_redolog1
/dev/rrk_redolog2
/dev/rrk_redolog3
/dev/rrk_redolog4

SQL> !ls -ltr /dev/rrk_redolog1
crwxr-xr-x 1 oracle dba       60,  4 Jul 09 14:25 /dev/rrk_redolog1

SQL> !ls -ltr /dev/rrk_redolog*
crwxr-xr-x 1 oracle dba       60,  7 Jul 09 14:25 /dev/rrk_redolog4
crwxr-xr-x 1 oracle dba       60,  6 Jul 09 14:25 /dev/rrk_redolog3
crwxr-xr-x 1 oracle dba       60,  5 Jul 09 14:25 /dev/rrk_redolog2
crwxr-xr-x 1 oracle dba       60,  4 Jul 09 14:25 /dev/rrk_redolog1

归档文件的情况如下：
-rw-r----- 1 oracle dba          1024 Jul 09 13:06 2_27870.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 13:06 1_27522.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 13:14 2_27871.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 13:14 1_27523.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 13:22 2_27872.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 13:22 1_27524.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 13:30 2_27873.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 13:30 1_27525.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 13:38 2_27874.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 13:38 1_27526.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 13:45 2_27875.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 13:46 1_27527.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 13:53 2_27876.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 13:54 1_27528.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:01 2_27877.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:01 1_27529.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:09 2_27878.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:10 1_27530.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:17 2_27879.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:18 1_27531.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:25 2_27880.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:25 1_27532.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:33 2_27881.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:33 1_27533.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:40 2_27882.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:40 1_27534.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:48 2_27883.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:48 1_27535.dbf
-rw-r----- 1 oracle dba          1024 Jul 09 14:56 2_27884.dbf
-rw-r----- 1 oracle dba    209714688 Jul 09 14:56 1_27536.dbf

分享0