关于sga_target参数的问题

我的sga_max_size大小事428M 将sga_target调到428M 后  重启时报错
ORA-00838  memory_target is too small  先谢谢各位了!
我也来说两句 查看全部回复

最新回复

  • ilsyx (2010-12-02 09:38:59)

    OERR: ORA 838 Specified value of MEMORY_TARGET is too small, needs to be at least %sM [ID 786820.1]
              Modified 15-SEP-2010     Type PROBLEM     Status PUBLISHED          

    Error: ORA-00838
    Text:  Specified value of MEMORY_TARGET is too small, needs to be at least %sM
    ---------------------------------------------------------------------------------------
    Cause: The specified value of MEMORY_TARGET was less than the sum of the specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.
    Action: Set MEMORY_TARGET to at least the recommended value.

    *** Important: The notes below are for experienced users - See Note:22080.1



    Show Related Information Related
    Products

        * Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

    Keywords
    MEMORY_TARGET
    Errors
    ORA-838

    Back to top
  • huangdh12 (2010-12-03 22:13:00)

    系统默认的时候sga_target 大小不是428m吧?  我的10g是568好像。  结果加大到1g了都还是提示太小