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

Is truncate autocommit in oracle?

1025


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075


Is it possible to insert comments into sql statements return in the data model editor ?

2513


How do I uninstall oracle client from windows?

962


Explain the truncate in oracle?

914


How to execute the package in oracle?

1039


What are the different types of failures that occur in Oracle database?

1016


What are the differences between number and binary_float in oracle?

1054


What are the various oracle database objects?

1093


Why is oracle database so popular?

949


What would you do with an in-doubt distributed transaction?

1916


what are the default admin accounts in Oracle 10g ?

919


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2046


How to call a stored function with parameters?

972


What does sharding mean?

947