How to Allocate Memory to Oracle
The Oracle Database Express Edition database software suit includes two memory types: System Global Area, or SGA; and Program Global Areas, or PGA. The former includes memory shared by processes from a single database instance while the latter contains memory related to server-side processes such as stack space and session information. The amount of memory allocated to each memory type can be adjusted from the database home page.
Other People Are Reading
Instructions
-
-
1
Access the database home page by directing your browser to either "http://127.0.0.1:8080/apex" or "http://host:port/apex" depending on whether it is on your local machine or on a remote machine. For the latter, replace "host" with the IP address where the database is located and "port" with the TCP port, which is typically 8080 unless you changed it during installation.
-
2
Click the "Administration" button and then click the "Memory" icon. If the application asks you to log in, provide the administrator user name and password, and then click "Login."
-
-
3
Select the "Configure SGA" option from the "Tasks" list, enter the value desired in MB and click "Apply Changes."
-
4
Access the "Program Global Area" option from the "Tasks" list, enter the value desired in MB and click "Apply Changes."
-
1
