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 / guneetinder singh

When an oracle server starts up it will allocate two memory
areas SGA(System global area) and PGA(Program Global Area).
SGA is allocated to the user when any new oracle instance
starts up at the server for sharing different data between
difference users.
PGA is allocated to the server when oracle server starts up.
in this only server processes can work.

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State all possible different index configurations a table can possibly have?

994


What happens if recursive calls get out of control?

1077


What is bulk copy or bcp in oracle?

1120


Explain the use of log option in exp command.

1115


Why is oracle used?

936


what are actual and formal parameters?

1104


What are the attributes of the cursor?

1000


Explain what are the type of synonyms?

1107


How to convert a date to char in oracle? Give one example.

1066


Give syntax for SQL and ORACLE joins.

1092


Why do we need oracle client?

945


What is Data Dictionary Cache in Oracle?

1163


How to find out what oracle odbc drivers are installed?

1040


Difference between varchar and varchar2 data types?

1182


What is the difference between pre-select and pre-query?

1211