What is mean by Program Global Area (PGA) ?
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
What is sequence?
How to view all columns in an existing table?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
what is reindexing?
How data locks are respected in oracle?
What is meant by a deadlock situation?
types of indexes and the rationale behind choosing a particular index for a situation.
Difference between varchar and varchar2 data types?
Does facebook use oracle?
What is null value in oracle?
What is an oracle transaction?
Point the difference between translate and replace?
Explain table?
Explain the use of rows option in imp command.
What are data pump export and import modes?