Interested to Buy Any Domain ? << Click Here >> for more details...
What is mean by Program Global Area (PGA) ?
- 9 Answers
- 22729 Views
- Bajaj, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sawant
It is area in memory that is used by a Single Oracle User
Process.
| Is This Answer Correct ? | 21 Yes | 2 No |
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 |
Answer / ram bhajan tiwari
when the user is going to use oracle application He will
connect to the server with PGA which system takes bydefault.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / hariharanadh
It is a memory buffer that contains data and control information for server process
A PGA created when oracle server starts and deallocated
when server process down
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / bhaskar
Hi,
It is the part of memory used by a singe process or thread.
Each oracle background process have PGA area.and is not
sharable.it get allocated when the process starts and gets
deallocated on completion of the process by oracle server.
It contains short area,session specific information,user
previliges,cursor state etc.It is writable only by the
server process.
Thanks-Bhaskar Gouda
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
It is area in memory that is used by a Single Oracle User Process. Whenever a server process is started a sertain amount of PGA memory is automatically allocated through the server process.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rashid ansari
if oracle user dedicated server then only oracle create PGA
for each user.
| Is This Answer Correct ? | 4 Yes | 4 No |
How to retrieve 5th highest sal from emp table?
Can I create users through internet explorer in oracle 10g?
wirte the syntax of update query?
How many types of segments in Oracle?
How would you go about verifying the network name that the local_listener is currently using?
What is DTS and purpose of DTS ?
How to count groups returned with the group by clause in oracle?
How do you ensure database security?
In the oracle version 9.3.0.5.0, what does each number shows?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to retrieve first and last records from a table?
Oracle General 
