Size & content of PGA is independent on Oracle server options installed - Oracle Architecture

Discussion

• Nirja Shah   -Posted on 26 Aug 15
  -The size and content of the PGA depends on the Oracle-server options installed.
  
  -This area consists of the following components:
  
  1. stack-space: the memory that holds the session's variables, arrays, and so on
  2. session-information: unless using the multithreaded server, the instance stores its session-information in the PGA.
  -In a multithreaded server, the session-information goes in the SGA.)
  3. private SQL-area: an area that holds information such as bind-variables and runtime-buffers
  4. sorting area: an area in the PGA that holds information on sorts, hash-joins, etc.
  
  -DBAs can monitor PGA usage via the system view.

➨ Post your comment / Share knowledge