What is mean by Program Global Area (PGA) ?
Answer Posted / munnu
PGA: Whenever a server process is started a sertain amount
of PGA memory is automatically allocated through the server
process. This memory area is a private SGA area of the
sever process and can be assed only by oracle code that
axts on behalf of that perticular server process.Two memory
area in the PGA are private SQL area and session memory.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Difference between varchar and varchar2 data types?
How to call a stored function with parameters?
What is the maximum limit on the number of columns in a table?
What to do if the startbd.bat failed to start the xe instance?
Explain an exception?
Explain the characteristics of oracle dba?
What is a subquery in oracle?
Explain about your project and its relation to the current job position you are applying to?
What is raw datatype?
How do I call oracle stored procedures that take no parameters?
Explain enable novalidate constraint.
How to initialize variables with default values?
What are temporal data types in oracle?
Explain a data segment?
How to delete a column in an existing table?