Lots of people landed on my blog by searching for “10g XE disadvantages”, but unfortunately I don’t have such an article. I mean until now
So what are the disadvantages of using 10g XE database? :
- it’s not supported by Oracle support
- it is working on just one processor core, no matter how many you have
- it will not use more than 1 GB of RAM, no matter how much RAM you have
- you cannot store more than 4 GB of user data, hard-coded limitation
- you’ll not find patches for it
- not yet a 11g version
Of course there are lots of advantages:
- very lightweight installation kit (~150 MB vs ~1700 GB for 11gR1)
- very easy installation
- not very intrusive, much less memory used compared to 11gR1
- very recommended for the application development process
- very recommended as a MySQL replacement
- same code as paid versions, just with some hard-coded limitations (see above)
As an example, I am using on my laptop both 10g XE and 11gR1 EE.
If I need to do a quick migration or something simple, I am starting 10g XE.
If I need to prove/test/play with some 11gR1 features, I am using 11gR1.