Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Change System Global Area (SGA) in Oracle?
Answer:
Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your server. If you are running this server just for yourself to improve your DBA skill, you should change the SGA size to 32MB by:
* Log into the server home page as SYSTEM.
* Go to Administration, then Memory.
* Click Configure SGA.
* Enter the new memory size: 32
* 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 SGA.
* Enter the new memory size: 32
* Click Apply Changes to save the changes.
* Re-start your server.
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Unlock the Sample User Account in Oracle? | How To Change Program Global Area (PGA) in Oracle? |