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
Difference between inner join vs where ?
How do I start tns listener?
Can we connect to ORACLE db using Windows Authentication?
Where are the settings stored for each instance in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to define a data field as not null?
What are the different oracle database objects?
Explain the use of indexes option in imp command.
How to connect asp pages to oracle servers?
query optmization techniques and quwry analyser+projects+ppts
How to test null values?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain the use of log option in exp command.
What is meant by joins?
Who developed oracle & when?