What is mean by Program Global Area (PGA) ?
- 9 Answers
- 19784 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
How to run create database statement?
What is an oracle function?
Explain an index?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Can we use bind variables in oracle stored procedure?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How do I limit the number of oracle database connections generated by weblogic server?
Explain how you would restore a database using RMAN to Point in Time?
How to estimate disk space needed for an export job?
Explain coalesce function?
Explain compound trigger in oracle?
Why do you use stored procedures and state some of its disadvantages?
What is pragma autonomous transaction in oracle?
Explain the use of parfile option in exp command.
How to bring a tablespace offline?
