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

Q.  The size and content of the PGA is independent on the Oracle server options installed.
- Published on 12 Aug 15

a. True
b. False



  • 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

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)