How you change program Global Area (PGA) in Oracle?
Submitted by: AdministratorYour 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.
Submitted 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.
Submitted by:
Read Online Oracle Database Developer Job Interview Questions And Answers
Top Oracle Database Developer Questions
☺ | How you can Download Oracle Database 10g XE? |
☺ | Explain Oracle Server Autotrace in Oracle? |
☺ | Explain Parameter File in Oracle? |
☺ | Explain System Global Area (SGA) in Oracle? |
☺ | Explain Initialization Parameter File in Oracle? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |