up vote 0 down vote favorite
share [g+] share [fb]

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc.

I want to migrate to Oracle XE. Can this edition serve as the primary database for a server?

Also, i am unclear, about is there any limit on:

  • Size of database, in terms of no. of records or memory size?
  • no. of concurrent connections?
  • CPU/other resource utilisation limits/impact?

Please guide.

link|improve this question
62% accept rate
feedback

2 Answers

up vote 2 down vote

Oracle Xpress Edition has several limitations, including:

  • A physical limit of 4GB for storage,
  • A limit of 1GB or RAM. Even if your server has more, it won't be used.
  • A limit of 1Cpu (or 1 core?). Even if your server has more, it won't be used.
  • No support from Oracle. You'll have to rely on good samaritan if you encounter any problem.

The details are on Oracle Website.

link|improve this answer
+1 Thanks for pointing to XE, even though i mentioned Lite. I gather now that Lite can not serve as a stand alone product. – Mohit Nanda Jul 6 '10 at 8:33
feedback
up vote 0 down vote

I think that Benoit is pointing you in the right direction with Oracle XE. Oracle Lite is a separate product meant for mobile devices. I can't see circumstances where you would switch from a full Oracle 10g to Oracle Lite

link|improve this answer
Thanks, have updated the question. – Mohit Nanda Jul 6 '10 at 8:32
1  
I didn't even know about the product for mobile devices.. – Benoit Jul 6 '10 at 13:11
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.