Private SQL area stores binding variables & runtime buffers information - Oracle Architecture

Q.  Which area of PGA stores binding variables and runtime buffers information?
- Published on 12 Aug 15

a. SQL area
b. Private SQL area
c. Stack space
d. Session area

ANSWER: Private SQL area
 

    Discussion

  • Nirja Shah   -Posted on 26 Aug 15
    -Some of the areas are:

    -Private SQL area - Each session issuing a SQL statement has a private SQL area in its PGA.
    -Each user that submits the same statement has a private SQL area pointing to the same shared SQL area.
    -Thus, many private SQL areas in separate PGAs can be associated with the same shared SQL area.

    -SQL Area - A work area is a private allocation of PGA memory used for memory-intensive operations.
    -For example, a sort operator uses the sort area to sort a set of rows. Similarly, a hash join operator uses a hash area to build a hash table from its left input, whereas a bitmap merge uses the bitmap merge area to merge data retrieved from scans of multiple bitmap indexes.

    -A stack space is different from PGA.
    -Stack Space - A PGA always contains a stack space, which is memory allocated to hold a session's variables, arrays, and other information.

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.)