What Are The Contents Of Pga?

1.	What Are The Contents Of Pga?
Answer» Content of the Program Global Area : The content of the Program Global Area memory varies, depending on whether the INSTANCE is running the shared server option. But in general, the PGA memory can be classified in the following manner. Private SQL Area : A private SQL area contains information such as bind information and runtime memory structures. CURSORS and SQL AREAS : Session memory is the memory assigned to hold a session's variables (logon information) and other session information. The session memory is shared and not private for a shared server. SQL WORK Areas: For complex queries such as decision-support queries, a big portion of the runtime area is dedicated to work areas allocated by memory- intensive operators.

Answer»

Content of the Program Global Area : The content of the Program Global Area memory varies, depending on whether the INSTANCE is running the shared server option. But in general, the PGA memory can be classified in the following manner.
Private SQL Area : A private SQL area contains information such as bind information and runtime memory structures.
CURSORS and SQL AREAS : Session memory is the memory assigned to hold a session's variables (logon information) and other session information. The session memory is shared and not private for a shared server.
SQL WORK Areas: For complex queries such as decision-support queries, a big portion of the runtime area is dedicated to work areas allocated by memory- intensive operators.

Discussion