1 Reply Latest reply: Jan 19, 2014 9:38 AM by clcarter RSS

How to interpret the Memory and User Data limit on Oracle Express Edition?

gptan Newbie
Currently Being Moderated

Hi,

 

The express edition has < 1GB of RAM, and < 11GB of user data

 

< 1GB of RAM --> is this a combination of SGA + pga aggregate target etc?

< 11GB of user data --> does it include temp, undo, system, sysaux tablespace or the temp/undo/system/sysaux has not such limitation?

  • 1. Re: How to interpret the Memory and User Data limit on Oracle Express Edition?
    clcarter Expert
    Currently Being Moderated

    >> combination of SGA + pga ?


    Yes. Total memory footprint for the instance can not exceed 1GiB, sga + pga is pretty much the definition of the instance memory size.


    >>  include temp, undo, system, sysaux ?


    Those tablespaces should not count towards the user database 11G limit. System and sysaux are for the instance catalog and resource monitoring/tuning utilities, don't put stuff there. Just don't. Using system or sys schemas for storing user data is just plain bad form.


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points