Multiple choice

What is 'private SQL-area' in Program Global Area in Oracle database?

  1. It is the memory that holds the session's variables, arrays and so on.

  2. In this, the database instance stores its session-information in the PGA and the session-information goes in the SGA.

  3. It is an area that holds information such as bind-variables and runtime-buffers.

  4. It is an area in the PGA that holds information on sorts, hash-joins etc.

  5. It has the information about memory utilization.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is called 'private SQL-area'. It has all the runtime-buffer related information for every database.

Keep practicing — related questions