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
How to create additional tablespaces for an new database?
What the is the diff between local index and global index. give some example.
How to load data through external tables?
What is a initialization parameter file in oracle?
What is save point in oracle database?
How to view existing locks on the database?
What are the ways tablespaces can be managed and how do they differ?
How do we get field detail of a table?
How many types of table in Oracle?
How to change system global area (sga) in oracle?
Explain what are the type of synonyms?
What do you mean by merge in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How do you tell what your machine name is and what is its IP address?
various types of hints and their usage