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 use an explicit cursor without open statements?
How do I reset a sequence in oracle?
material view and view disadvantages?
how to join query for one source type is oracle another source type is sql server ?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Difference between cartesian join and cross join?
How do I recompile a procedure in oracle?
What is coalesce function?
What is the difference between a hot backup and a cold backup in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is an oracle tablespace?
How to recover a dropped table in oracle?
What are the limitations of check constraint?
What is a private synonym?