Trying Out S-ASH: Historical Performance Data for the Under-Licensed
I was recently playing with an Oracle XE database. The main benefit of Oracle XE is that it can be used free of charge. And unlike the other database editions on the Oracle Technology Network, it is free of the restrictions in the OTN license agreement that restrict products to "developing, testing, prototyping and demonstrating your application" only; you can even use Oracle XE in production if you choose to. XE also has the side benefit of being slightly newer (188.8.131.52 instead of 184.108.40.206, effectively 6 months worth of bugfixes incorporated). And, for fans of Red Hat Linux, the installation is dead easy: download and install the RPM, run a setup script, and you have a database (and application server) ready to run. To avoid cannibalizing product revenues, Oracle has imposed a number of technical limits that make XE unsuitable for most places you would use an Oracle database:
- Database resource manager is hard-coded to restrict CPU usage to one CPU core's worth.
- RAM usage is limited to 1GB.
- Data size is limited to 11GB.
- You can't circumvent these restrictions by running multiple databases or software installs.