2.2 Checking the MEMORY_TARGET of the Target Database

Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300 MB.

Databases typically use automatic memory management, where the memory can be controlled by the server parameter MEMORY_TARGET. If your database does not use automatic memory management, consult the Oracle Database Administrator's Guide to find out how to configure manual memory parameters (for example, SGA_TARGET, PGA_AGGREGATE_TARGET, SHARED_POOL_SIZE) instead, for a similar result.

To check the MEMORY_TARGET of the target database:

1. Start the database:

   SQL> STARTUP
   

2. If necessary, enter the following command to determine whether the system uses an initialization parameter file (initsid.ora) or a server parameter file (spfiledbname.ora):

   SQL> SHOW PARAMETER PFILE;
   

   This command displays the name and location of the server parameter file or the initialization parameter file.

3. Determine the current values of the MEMORY_TARGET parameter:

   SQL> SHOW PARAMETER MEMORY_TARGET
   

4. If the value is 0, your database is using manual memory management. Consult the Oracle Database Administrator’s Guide to learn how to configure an equivalent memory size using manual memory management, instead of continuing with the steps that follow.

   If the system is using a server parameter file, set the value of the MEMORY_TARGET initialization parameter to at least 300 MB:

   SQL> ALTER SYSTEM SET MEMORY_TARGET='300M' SCOPE=spfile;
   

5. If the system uses an initialization parameter file, change the value of the MEMORY_TARGET parameter to at least 300 MB in the initialization parameter file (initsid.ora).
6. Shut down the database:

   SQL> SHUTDOWN
   

7. Restart the database:

   SQL> STARTUP
   

See Also:

Oracle Database Administrator’s Guide