If Oracle Database XE is installed on a computer with more than one CPU, 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 will use both CPUs to efficiently process the queries. However, with Oracle Database XE, the Oracle database will process the queries at the rate of a single CPU. To use the full processing resources of your computer, upgrade to Oracle Database 10g Standard Edition or Oracle Database 10g Enterprise Edition.
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 or Enterprise Edition. In addition, users can run only one instance of the Oracle Database XE database at a time. 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 or Enterprise Edition.
The maximum amount of user data in an Oracle Database XE 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 or Enterprise Edition.
The maximum amount of RAM that an Oracle Database XE Server database uses cannot exceed 1 gigabyte. Table 1, "Oracle Database XE Requirements" provides the minimum and maximum RAM that you should use. To use more than 1 gigabyte of RAM, upgrade to Oracle Database 10g Standard Edition or Oracle Database 10g Enterprise Edition
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29987/viewspace-51890/ ,如需转载,请注明出处,否则将追究法律责任。