Question: why pga is used in oracle?
Answer: About the Program Global Area. The Program Global Area (PGA) is a private memory region that contains the data and control information for a server process. ... Oracle Database reads and writes information in the PGA on behalf of the server process. An example of such information is the run-time area of a cursor.