最新更新主题

月度关注热点

求助

字体: 小 中 大 | 打印 发表于: 2008-8-11 16:46    作者: iweifang    来源: CNOUG博客首页

我的服务器是浪潮拼牌的。操作系统是2003server，oracle版本oracle10。2。1
目前oracle装在d： 数据放在阵列盘z：
现在每天产生1.5G的归档日志。大侠帮助分析一下呀
我也来说两句 查看全部回复

最新回复

  • yzsind (2008-8-11 19:25:54)

    分析什么？

  • iweifang (2008-8-12 16:02:28)

    不好意思呀，
    我上传的附件没有成功。
    下面是 alter*.log 里的部分内容

    Memory Notification: Library Cache Object loaded into SGA
    Heap size 4838K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:38:40 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 3628K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:41:27 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 4838K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:42:00 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 3629K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:42:29 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 4838K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:42:29 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 3629K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:42:40 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 4839K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:42:40 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 3629K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 12:46:46 2008
    Memory Notification: Library Cache Object loaded into SGA
    Heap size 4839K exceeds notification threshold (2048K)
    Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2472.trc
    KGL object name :select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$
    Mon Aug 11 14:06:21 2008
    Thread 1 advanced to log sequence 3866
      Current log# 1 seq# 3866 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
    Mon Aug 11 14:18:19 2008
    Thread 1 advanced to log sequence 3867
      Current log# 2 seq# 3867 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
    Mon Aug 11 14:20:35 2008
    Thread 1 advanced to log sequence 3868
      Current log# 3 seq# 3868 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
    Mon Aug 11 14:40:54 2008
    Thread 1 advanced to log sequence 3869
      Current log# 1 seq# 3869 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
    Mon Aug 11 14:45:54 2008
    Thread 1 advanced to log sequence 3870
      Current log# 2 seq# 3870 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
    Mon Aug 11 14:55:25 2008
    Thread 1 advanced to log sequence 3871
      Current log# 3 seq# 3871 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
    Mon Aug 11 15:15:28 2008
    Thread 1 advanced to log sequence 3872
      Current log# 1 seq# 3872 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
    Mon Aug 11 15:39:20 2008
    Thread 1 advanced to log sequence 3873
      Current log# 2 seq# 3873 mem# 0: Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

  • TracyKelvin (2008-8-12 18:02:48)

    Heap size 4839K exceeds notification threshold (2048K)
    ???

  • wqqzlm520 (2008-8-12 20:36:56)

    把SGA分配发出来

  • iweifang (2008-8-14 17:13:36)

    processes                = 300
      sessions                 = 335
      __shared_pool_size       = 180355072
      __large_pool_size        = 4194304
      __java_pool_size         = 4194304
      __streams_pool_size      = 0
      nls_language             = SIMPLIFIED CHINESE
      nls_territory            = CHINA
      sga_target               = 612368384
      control_files            = Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, Z:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
      db_block_size            = 8192
      __db_cache_size          = 415236096
      compatible               = 10.2.0.1.0
      log_archive_dest_1       = LOCATION=z:\backlog
      db_file_multiblock_read_count= 16
      undo_management          = AUTO
      undo_tablespace          = UNDOTBS1
      remote_login_passwordfile= EXCLUSIVE
      db_domain                =
      dispatchers              = (PROTOCOL=TCP) (SERVICE=orclXDB)
      job_queue_processes      = 10
      audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
      background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
      user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
      core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
      db_name                  = orcl
      open_cursors             = 300
      pga_aggregate_target     = 203423744

    sga是物理内存的一半多点
    ORA-01652: unable to extend temp segment by 128 in tablespace TSP_TEMP

  • yzsind (2008-8-15 18:20:19)

    alert.log没什么特别的问题，不知道楼主想要大家分析什么？

    Memory Notification: Library Cache Object loaded into SGA
    Heap size 4839K exceeds notification threshold (2048K)

    关于上面这个警告可以参考以下文章的解释和处理方法。

    http://www.linuxgoo.com/2005/6716/11263466659.html

    http://www.loveunix.cn/html/32/1132-14563.html
查看全部回复 我也来说两句