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?
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