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
How to assign query results to variables?
How to connect to a local oracle 10g xe server?
Explain about integrity constraint?
What is oracle used for?
What happens if variable names collide with table/column names?
What are the ansi data types supported in oracle?
Explain about your project and its relation to the current job position you are applying to?
When system tablespace is created?
What is the use of oracle?
Explain what does a control file contain?
How to connect the oracle server as sysdba?
Explain the use of record length option in exp command.
What is an oracle function?
Why do you create or replace procedures rather that drop and recreate.
What is bind variable in oracle 11g?