3 Replies Latest reply: Nov 13, 2012 9:51 PM by 965009 RSS

    关于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