Program Global Areas (PGA) Overview
The Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is a nonshared memory created by Oracle whenever a server process is started and access to it is exclusive to that server process. Oracle code acting on behalf of the process is the only thing that has read or write access to the PGA.
The PGA is allocated when the server process is started, and the total PGA memory allocated by each server process attached to an Oracle instance is referred to as the aggregated PGA memory allocated by the instance.
Although the content of the PGA memory varies, depending on whether the instance is running the shared server option, the PGA memory can be classified ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
