3 回覆 最後回覆日期:Nov 14, 2012 3:51 AM,建立者:965009

    关于64-bit Windows下32-bit oracle的SGA设置问题

    962699
      ML:
      麻烦帮看看64-bit Windows下的32-bit oracle如何突破SGA限制?
      System Settings
      Setting      Value
      Platform      64-bit Windows Server (R) 2008 Enterprise
      O/S Version      6.0
      Service Pack      No Service Packs installed
      Memory 16GB

      Banner
      Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
      PL/SQL Release 10.2.0.3.0 - Production
      CORE 10.2.0.3.0 Production
      TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
      NLSRTL Version 10.2.0.3.0 - Production

      V$Sga
      Name      Value
      Database Buffers      738197504
      Fixed Size      1416576
      Redo Buffers      4259840
      Variable Size      1042899584