Interested to Buy Any Domain ? << Click Here >> for more details...
What is mean by Program Global Area (PGA) ?
- 9 Answers
- 22323 Views
- Bajaj, I also Faced
- E-Mail Answers
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 are the roles of dba?
How to call a sub procedure?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to update values on multiple rows in oracle?
What are ddl statements in oracle?
How to drop an index?
How to recover a dropped table in oracle?
How to define an oracle cursor variable?
What is oracle datasource?
How do I recompile a procedure in oracle?
Is a rollback possible to any savepoint?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the usage of save points in oracle database?
How to define a record variable to store a table row?
