0

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.

M.N
  • 337
  • 3
  • 7
  • 15

2 Answers2

2

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.

Benoit
  • 3,499
  • 1
  • 18
  • 17
  • +1 Thanks for pointing to XE, even though i mentioned Lite. I gather now that Lite can not serve as a stand alone product. – M.N Jul 06 '10 at 08:33
0

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

Gary
  • 1,839
  • 10
  • 14