Oracle Database Developer Question:
Download Job Interview Questions and Answers PDF
How you change program Global Area (PGA) in Oracle?
Answer:
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.
* 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.
Download Oracle Database Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How you can Change System Global Area (SGA) in Oracle? | What happened if you Set the SGA Too Low in Oracle? |