What is Program Global Area (PGA)

Q

What is Program Global Area (PGA)? - Oracle DBA FAQ - Oracle Basic Concepts

✍: 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.

2007-04-21, 4877👍, 0💬