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 :)

xe_logoSo 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.

Good luck!

Related posts:

Tags: , , ,
6 Responses to “Disadvantages of using Oracle Database 10g XE (Express Edition)”
  1. ionut says:

    i found it useful when studying databases at university because it provided just the features i need. What upsets me the most is that it automatically starts as a sevice and uses about 100mb of memory when standing by.

  2. andreiash says:

    Well, my brother, you have three options:
    1. put the service on manual and start only when you need it
    2. install the database on another network machine
    3. install 11g to see how much memory is using and then you’ll feel happy with the 100MB you were talking about

  3. Yoni says:

    I just wish they loosen the space limitation a bit in the next version of XE to at least 10GB.

  4. andreiash says:

    I really doubt. It’s better to wish an 11g XE version with the same features like 10g one ;)

  5. b says:

    11g XE user space limit is 11GB! Yay! :D

  6. Roger says:

    A database having more than 50 variables have been tried out in Oracle 10g Express edition, but while viewing the table only 31 columns are displayed. Can any one tell me the reasons or the disadvantages?

Leave a Reply