Which area of PGA stores binding variables and runtime buffers information?

Options
- SQL area
- Private SQL area
- Stack space
- Session area

CORRECT ANSWER : Private SQL area

Discussion Board
23

234

wrtrrr 12-29-2019 12:59 AM

PGA

Private SQL area of PGA stores binding variables and runtime buffers information. 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.

Prajakta Pandit 02-17-2017 12:50 AM

Write your comments


Enter the code shown above:

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


Related Content

Advertisement
 
▲