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, 1693👍, 0💬

Popular Posts:

"sys.tables" - Getti...

How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...

Download Oracle Data...

How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...

CREATE VIEW - Creati...

How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...

"ALTER TABLE ... ALT...

How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...