What is mean by Program Global Area (PGA) ?
- 9 Answers
- 19844 Views
- Bajaj, I also Faced
- E-Mail Answers
Answer Posted / munnu
PGA: Whenever a server process is started a sertain amount
of PGA memory is automatically allocated through the server
process. This memory area is a private SGA area of the
sever process and can be assed only by oracle code that
axts on behalf of that perticular server process.Two memory
area in the PGA are private SQL area and session memory.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is a trace file and how is it created in oracle?
How to use regular expression in pattern match conditions in oracle?
How do I manually uninstall oracle client?
How can we find out the duplicate values in an oracle table?
How to define a variable of a specific record type?
What is instant client oracle?
Explain the features of oracle?
How to rebuild an index in oracle?
What is meant by an index?
Can the query output be sorted by multiple columns in oracle?
What are a cluster and non-cluster index?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Why packages are used in oracle?
Which is faster join or subquery in oracle?
What is a tns service name?
