0 Replies Latest reply: Aug 15, 2013 12:03 PM by dgathman RSS

    XE 11g R2 Memory Constraint (1GB) Exceeded

    dgathman

      I'm attempting to figure out how many connections (dedicated server) Windows Oracle XE 11g R2 can support based on the published 1GB (SGA+PGA) memory limit. I've used the following query to view memory consumption, and it appears that more than 1GB is being used.  Is my query flawed, or is XE using more that 1GB?

       

      SELECT PU.PGA_USED,

                      PA.PGA_ALLOC,

                       D.SGA,

                      PU.PGA_USED + D.SGA AS PGA_USED_AND_SGA,

                      PA.PGA_ALLOC + D.SGA AS PGA_ACLLOC_AND_SGA,

                      (SELECT COUNT(*) FROM V$SESSION WHERE PROGRAM = 'xxxx') AS SESS_CT

         FROM (SELECT ROUND(SUM(PGA_USED_MEM)/1024/1024,2) AS PGA_USED FROM V$PROCESS) PU,

                      (SELECT ROUND(SUM(PGA_ALLOC_MEM)/1024/1024,2) AS PGA_ALLOC FROM V$PROCESS) PA,

                       (SELECT ROUND(SUM(CURRENT_SIZE)/1024/1024,2) AS SGA FROM V$SGA_DYNAMIC_COMPONENTS) D

       

      PGA_USEDPGA_ALLOCSGAPGA_USED_AND_SGAPGA_ALLOC_AND_SGASESS_CT
      709.49880.196601369.491540.19783