Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the database name in oracle?

1076


What is an oracle database?

1103


What happens if you lost a data file?

1080


What is execute immediate in oracle?

1076


What is Reduced List of Values?

2242


What is PL/SQL ?

2207


How to execute a stored program unit?

1126


What are the differences between char and varchar2 in oracle?

1245


How can you merge two tables in oracle?

1046


Does oracle partitioning improve performance?

1051


How to assign values to variables?

1163


What is Undo Management Advisor in Oracle?

1151


What is the difference between substr & instr functions?

1292


How do I connect to oracle?

1078


How to establish administrator authentication to the server?

1094