Program Global Area (PGA) The Program Global Area or Process Global Area (PGA) is a memory region that contains data and control information for a single server process or a single background process. The PGA is allocated when a process is created and deallocated when the process is terminated. The total PGA memory allocated by [...]
Archive for the ‘Oracle Memory’ Category
27 Feb
Oracle SQL Execution Steps
All Oracle SQL statements must be processed the first time that they execute (unless they are cached in the library cache). and SQL execution steps include: A syntax check – Are all keywords present "select . . . from", etc . . A semantic check against the dictionary – Are all table names spelled correctly, [...]
