Oracle - Change Program Global Area (PGA) in Oracle

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

2016-10-17, 565👍, 0💬

💬 2017-07-10 sasi: Nice tutorial..

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 3655👍, 0💬

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 698👍, 1💬

💬 2017-07-10 Kumar Kedi: ascdfwtwert

Privilege Needed to Connect to Oracle Server in Oracle
What Privilege Is Needed for a User to Connect to Oracle Server in Oracle? Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL&a... 2019-07-09, 525👍, 0💬

Change User Password in Oracle
How To Change User Password in Oracle? If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> ALTER USER DEV IDENTIFIED BY beginner; U... 2019-07-09, 513👍, 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.