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
State all possible different index configurations a table can possibly have?
What happens if recursive calls get out of control?
What is bulk copy or bcp in oracle?
Explain the use of log option in exp command.
Why is oracle used?
what are actual and formal parameters?
What are the attributes of the cursor?
Explain what are the type of synonyms?
How to convert a date to char in oracle? Give one example.
Give syntax for SQL and ORACLE joins.
Why do we need oracle client?
What is Data Dictionary Cache in Oracle?
How to find out what oracle odbc drivers are installed?
Difference between varchar and varchar2 data types?
What is the difference between pre-select and pre-query?