Size & content of PGA is independent on Oracle server options installed - Oracle Architecture
Oracle (MCQ) questions and answers
Q. The size and content of the PGA is independent on the Oracle server options installed.
- Published on 12 Aug 15
Oracle DBA (
Oracle Replication (
Oracle Architecture (
Oracle Transaction (
Administering and Managing an Oracle Database (
Managing Oracle Database Processes (
Oracle Control Files (
Oracle Redo Log (
Oracle Tablespaces (
Oracle Datafiles and Tempfiles (
Oracle Managed Files (
Oracle Schema (
Oracle Tables (
Oracle Indexes and Partitioned Tables (
Oracle Clusters (
Oracle Views, Sequences, and Synonyms (
Oracle Distributed Database concepts (
-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.)