Saturday, 17 September 2016

Oracle Database Express Edition Limitations - CPU | RAM | STORAGE

Oracle Database Express Edition Limitations:

How Oracle Database Express Edition differs from Oracle Database Standard Edition or Oracle Database Enterprise Edition? 

Limitations  in terms of CPU Usage, RAM Usage and Data Storage

Oracle DB Express Editions use different amount of resource on your system as compare to Oracle DB Standard Edition or Enterprise Edition. These limitations are useful as well as useless depending upon the purpose that you are installing Oracle database software on your computer. But first of all, let's see what those limitations are:

CPU Limitations

If Oracle Database XE Server is installed on a computer with more than one CPU (including dual-core CPUs), then it will consume, at most, processing resources equivalent to one CPU. For example, on a computer with two CPUs, if two Oracle database clients try to simultaneously execute CPU-intensive queries, then Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition will use both CPUs to efficiently process the queries. However, with Oracle Database XE Server, the Oracle database will process the queries at the rate of a single CPU even if concurrent processing on two CPUs would be faster. To use the full processing resources of your computer, upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Ed

Data/Space Limitations

The maximum amount of user data in an Oracle Database XE Server database cannot exceed 4 gigabytes. If the user data grows beyond this limit, then an ORA-12592 error will appear. To use more than 4 gigabytes of user data, upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition.

RAM Limitations

The maximum amount of RAM that an Oracle Database XE Server database uses cannot exceed 1 gigabyte, even if more is available. Table 1, “Oracle Database XE Requirements” provides the minimum and recommended RAM that you should use. The exact amount of RAM that Oracle Database XE uses is the sum of the System Global Area (SGA) and the aggregate Program Global Area (PGA). To find this value, follow these steps after you have installed Oracle Database XE:
  • Click the Main menu (on Gnome) or the K menu (on KDE), select Oracle Database 10g Express Edition, and then select Go to Database Home Page.
  • In the Database Home Page, log in as SYSTEM.
  • Under Usage Monitor, click the Memory link.
  • Check the Current Configuration (SGA + PGA) setting
  • Installation Limitations
On a single computer, only one installation of the Oracle Database XE software can be performed. This does not affect any existing installation or new installations of Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition. In addition, users can run only one instance of the Oracle Database XE database on each individual computer. To run more than one Oracle Database server instance or install more than one copy of the database software, upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition.

HTTPS Limitations

HTTPS is not supported natively with the HTTP listener built into Oracle Database XE. If you want HTTPS support, use an alternative Web listener, such as Apache, that does provide HTTPS support, and provide proxies for the URLs provided by Oracle Database XE.

Conclusion:

As I said that whether these limitations are good or bad completely depends upon the purpose you are installing the Oracle Database Software. See, if you are full or resources, means, if you have a system fully equipped with resource like more RAM, processor speed and storage as well; you can always go with the Oracle Database Enterprise Edition or Standard Edition (whether you are installing it for Commercial Use or just to practice). But Oracle Express Edition is really helpful when you don't want to spend more resource on Oracle Database Software as well as want to use it. Obviously, it will not be having all the features that you'll get in Standard or Enterprise Edition but still it is worth practising and learning Oracle Database Working Structure.

More About Oracle Database Express Edition Limitations (Will be update shortly)

No comments:

Post a comment