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

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