Interested to Buy Any Domain ? << Click Here >> for more details...
What is mean by Program Global Area (PGA) ?
- 9 Answers
- 22711 Views
- Bajaj, I also Faced
- E-Mail Answers
Answer Posted / guneetinder singh
When an oracle server starts up it will allocate two memory
areas SGA(System global area) and PGA(Program Global Area).
SGA is allocated to the user when any new oracle instance
starts up at the server for sharing different data between
difference users.
PGA is allocated to the server when oracle server starts up.
in this only server processes can work.
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
How to view all columns in an existing table?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain integrity constraint?
What is a trigger and what are its types in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to insert multiple rows with one insert statement in oracle?
What is the data type of dual table?
How to invoke the original export import utilities?
How to resolve name conflicts between variables and columns?
How do we get field detail of a table?
What is the implicit cursor in oracle?
Does oracle partitioning improve performance?
How to define a data field as not null?
What is rowid and rownum in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
