Oracle Database 10g Express Edition (Oracle Database XE) is free to develop, deploy and distribute and is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base. Adrian Bridgwater samples a cup of this fresh new brew.
As stated above, Oracle Database XE is positioned as an entry-level product, as such it is a great starter database for:
• Developers working on PHP, Java, .NET and Open Source applications
• DBAs who need a free, starter database for training and deployment
• Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
• Educational institutions and students who need a free database for their curriculum
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
Is it really free?
Oracle Database XE really is for free development. There are no database license costs associated with developing applications for the product and it is offered using the complete integrated set of Oracle Database programming interfaces. This includes SQL, PL/SQL, Java, C and PHP, Windows .Net, Oracle Application Express, C++, ODBC and OLE DB.
Developers can then freely distribute Oracle Database XE as a standalone database or as part of a third-party application or product, provided the defined criteria are adhered to.
“Oracle Database XE allows developers, DBAs, ISVs and students the opportunity to learn, develop and deploy on the world’s leading database software, at no cost,” said Thomas Kyte, vice president, Oracle. “No one has to make do anymore; everyone can now start with the best.”
“Developers, DBAs, students and ISVs often look to no cost DBMSs to get started in developing and learning to develop database applications,” said Carl Olofson, research director for information management and data integration software research at analyst firm IDC. “When such a DBMS is supported by a wealth of literature, online technical material and professional experts, it allows developers to easily grow and support their applications and data needs over time without needing to convert their database later on, the result is a low risk path that offers a high potential return not only immediately, but in the long run.”
When such a DBMS is so well supported... it allows developers to easily grow and support their applications and data needs over time without needing to convert their database later on.
How do I manage Oracle Database XE?
Oracle Database XE comes complete with its own management browser interface to monitor database activity and manage database users, storage and memory. The Oracle Database 10g product family offers many different options and features across different editions. For a complete comparison, see oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family.pdf