

Under Usage Monitor, click the Memory link.Ĭheck the Current Configuration (SGA + PGA) setting:ĭescription of the illustration memory.gifįor more information about managing memory, refer to Oracle Database Express Edition 2 Day DBA. In the Database Home Page, log in as SYSTEM. To find this value, follow these steps after you have installed Oracle Database XE:Ĭlick 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. 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). Table 1, "Oracle Database XE Requirements" provides the minimum and recommended RAM that you should use. The maximum amount of RAM that an Oracle Database XE Server database uses cannot exceed 1 gigabyte, even if more is available. Oracle Database XE home page on Oracle Technology Networkīefore you can use the discussion forum, you need to register Oracle Database XE.ģ.4 Oracle Database XE Server RAM Limitation It is not supported on Oracle Database XE Client.įor more information on Oracle Database XE, visit the following Web sites: Install Zend Core for Oracle on Oracle Database XE Server only. Zend Core for Oracle: Download and install from: You can install PHP on either Oracle Database XE Server or Oracle Database XE Client. You can use either of the following PHP products: PHP is an open-source server-side embedded scripting language that is designed for Web development and can be embedded in HTML.

In addition, you can use PHP with Oracle Database XE. Use this installation executable only on remote computers-that is, only on computers on which you do not install Oracle Database XE Server.Īfter you install Oracle Database XE, you can manage it by using the Oracle Database XE graphical user interface management console, described in Oracle Database Express Edition 2 Day DBA. NET, PHP, and Oracle Application Express applications. Oracle Database Client provides drivers, networking components, and tools that enable you to remotely administer the database and to develop Java.

Oracle Database XE Client: You install the Oracle Database XE client component on remote computers from which you want to connect to Oracle Database XE.

It also includes the client component of Oracle Database XE, so that you can connect to the database from the same computer on which you installed the server component, and then administer the database and develop Java. Oracle Database XE Server: The Oracle Database XE Server component provides both an Oracle database and tools for managing this database. The installation has the following components:
