What Is Program Global Area (PGA) in Oracle

What Is Program Global Area (PGA) in Oracle

Q

What Is Program Global Area (PGA) in Oracle?

✍: FYIcenter.com

A

A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies the total memory allocated by all sessions, and changes will take effect as new sessions are started.

Â

â‡’Oracle Database Basic Concepts

â‡’â‡’Oracle Database Tutorials

2020-07-07, 2103👍, 0💬

Popular Posts:

Show Privileges of t...

How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...

What Is Microsoft SQ...

What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...

CONVERT() - Converti...

How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...

Oracle Database Basi...

Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle dat...

Recover a Dropped In...

How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...