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 SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

Answer Posted / sawant

The System Global Area in a Oracle database is the
area in memory to facilitates the transfer of information
between users. It holds the most recently requested
structural information between users. It holds the most
recently requested structural information about the database.

The structure is Database buffers, Dictionary cache, Redo
Log Buffer and Shared SQL pool (ver 7.0 only) area.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by merge in oracle and how can we merge two tables?

1018


What are the differences between interval year to month and interval day to second?

989


types of indexes and the rationale behind choosing a particular index for a situation.

2469


What happens to the indexes if a table is recovered?

959


What is the Tune Query

2249


How to find the duplicate rows count from employees table in oracle?

1059


What is the difference between substr & instr functions?

1166


How to use attributes of the implicit cursor in oracle?

969


What are the different types of trigger and explain its various uses and functions?

1033


How to change user password in oracle?

985


How to create a new oracle data file?

999


What is an external table?

978


Calculate difference between 2 date / times in oracle sql?

1010


How to call a sub procedure?

1052


What are the different oracle database objects?

1051