Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Change Program Global Area (PGA)
(Continued from previous topic...)
How To Change Program Global Area (PGA)?
Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB.
The PGA size can be changed to a new value depending on how much data a single session
should be allocated. If you think your session will be short with a small amount of data,
you should change the PGA size to 16MB by:
- Log into the server home page as SYSTEM.
- Go to Administration, then Memory.
- Click Configure PGA.
- Enter the new memory size: 16
- Click Apply Changes to save the changes.
- Re-start your server.
(Continued on next topic...)
- What Is Oracle Database 10g Express Edition?
- What Are the Limitations of Oracle Database 10g XE?
- What Operating Systems Are Supported by Oracle Database 10g XE?
- How To Download Oracle Database 10g XE?
- How To Install Oracle Database 10g XE?
- How To Check Your Oracle Database 10g XE Installation?
- How To Shutdown Your 10g XE Server?
- How To Start Your 10g XE Server?
- How Much Memory Your 10g XE Server Is Using?
- How To Start Your 10g XE Server from Command Line?
- How To Shutdown Your 10g XE Server from Command Line?
- How To Unlock the Sample User Account?
- How To Change System Global Area (SGA)?
- How To Change Program Global Area (PGA)?
- What Happens If You Set the SGA Too Low?
- What To Do If the StartDB.bat Failed to Start the XE Instance?
- How To Login to the Server without an Instance?
- How To Use "startup" Command to Start Default Instance?
- Where Are the Settings Stored for Each Instance?
- What To Do If the Binary SPFile Is Wrong for the Default Instance?
- How To Check the Server Version?