Change Program Global Area (PGA) in Oracle

Q

How To Change Program Global Area (PGA) in Oracle?

✍: FYIcenter.com

A

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.

Â

â‡’Introduction to Oracle Database 10g Express Edition

â‡’â‡’Oracle Database Tutorials

2020-09-30, 2001👍, 0💬

Change Program Global Area (PGA) in Oracle
How To Change Program Global Area (PGA) in Oracle? 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 o... 2020-09-30, 2002👍, 0💬

Change System Global Area (SGA) in Oracle
How To Change System Global Area (SGA) in Oracle? 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 improv... 2020-09-30, 1680👍, 0💬

Start 10g XE Server from Command Line in Oracle
How To Start Your 10g XE Server from Command Line in Oracle? You can start your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StartDB.bat. The batch file StartDB.bat contains: net start OracleXETNSListener net... 2020-10-10, 1675👍, 0💬

Start the Default Instance in Oracle
How To Use "startup" Command to Start Default Instance in Oracle? If you logged in to the server as a SYSDBA, you start the default instance with the "startup" command. Here is how to start the default instance in SQL*Plus in SYSDBA mode: >.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SY... 2020-09-15, 1298👍, 0💬

Memory Usage of 10g XE Server in Oracle
How Much Memory Your 10g XE Server Is Using in Oracle? Your 10g XE Server is using about 180MB of memory even there is no users on the server. The server memory usage is displayed on your server home page, if you log in as SYSTEM. Â â‡’ Introduction to Oracle Database 10g Express Edition â‡’â‡... 2020-10-10, 1283👍, 0💬

Instance Settings Stored in SPFile in Oracle
Where Are the Settings Stored for Each Instance in Oracle? Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOME\database directory. A paramete... 2020-09-15, 1256👍, 0💬

SGA Setting Is Too Low in Oracle
What Happens If You Set the SGA Too Low in Oracle? Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you try to connect to your server home page: http://localhost:80... 2020-09-30, 1246👍, 0💬

Shutdown 10g XE Server from Commmand Line in Oracle
How To Shutdown Your 10g XE Server from Command Line in Oracle? You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The batch file StopDB.bat contains: net stop OracleServiceXE Â ... 2020-10-10, 1234👍, 0💬

Login to Server without an Instance in Oracle
How To Login to the Server without an Instance in Oracle? If your default instance is in trouble, and you can not use the normal login process to reach the server, you can use a special login to log into the server without any instance. Here is how to use SQL*Plus to log in as a system BDA: >... 2020-09-15, 1225👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.