What is mean by Program Global Area (PGA) ?
Answer Posted / 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 |
Post New Answer View All Answers
What is the database name in oracle?
What is an oracle database?
What happens if you lost a data file?
What is execute immediate in oracle?
What is Reduced List of Values?
What is PL/SQL ?
How to execute a stored program unit?
What are the differences between char and varchar2 in oracle?
How can you merge two tables in oracle?
Does oracle partitioning improve performance?
How to assign values to variables?
What is Undo Management Advisor in Oracle?
What is the difference between substr & instr functions?
How do I connect to oracle?
How to establish administrator authentication to the server?