What is mean by Program Global Area (PGA) ?
- 9 Answers
- 19822 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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Can a formula column be obtained through a select statement ?
How do I learn what codesets are available in oracle?
What is the parameter mode that can be passed to a procedure?
What to do if the binary spfile is wrong for the default instance?
How would you change old and new values in an insert, delete and update triggers?
Where is the export dump file located?
Are truncate and delete commands same? If so why?
What is bulk load in oracle?
Explain an exception?
What is PL/SQL ?
Can you create a synonym without having a table?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is an index associated with a constraint?
How to connect asp pages to oracle servers?
