Configuring Program Global Area Memory |
 Previous |
 Next |
The Program Global Area (PGA) is a memory area used by a single Oracle server process. The amount of memory allocated to the PGA directly affects the performance of your database. The PGA sizes are configured automatically when you install Oracle Database XE.
To alter PGA memory:
-
On the Database Home Page, click the Administration icon.
-
Click Memory.
-
If prompted, enter the appropriate administrator username and password and click Login.
The Memory page appears. See "Viewing Current Memory Utilization".
-
On the Tasks list, click Configure PGA.
-
In Aggregate PGA Target, enter a new value in MB.
-
Click Apply Changes.
|
See Also: "About Program Global Area Memory", "Viewing Current Memory Utilization", and "Managing Database Memory" in Oracle Database Express Edition 2 Day DBA Guide |