What is mean by Program Global Area (PGA) ?
- 9 Answers
- 19783 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
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Is it possible to split the print reviewer into more than one region ?
what is the scenario where you take the database to NoArchivelog mode?
How can we delete duplicate rows in a table?
How to upsert (update or insert into a table)?
What is a subquery in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to select an oracle system id (sid)?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain what are the different type of segments?
What happens if you use a wrong connect identifier?
What is meant by joins? List out the types of joins.
What are the logical operations?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
