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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Wat is SGA ?

Question Posted / avinash pradhan

Answers were Sorted based on User's Feedback



Wat is SGA ?..

Answer / swapneswar

system global area(SGA) is a shared memory regionallocated
by ORACLE that contains data and control information for
one ORACLE instance

Is This Answer Correct ?    7 Yes 0 No

Wat is SGA ?..

Answer / mohit lalwani

SGA known as System Global Area and is a part of the Oracle instance.

SGA consist of different memory structures which are

-Shared pool (mandatory)
-Database Buffer Cache (mandatory)
-Redo Log Buffer (mandatory)
-Large Pool (optional)
-Java Pool (optional)

-SGA is sized by sga_max_size

Is This Answer Correct ?    2 Yes 0 No

Wat is SGA ?..

Answer / narayan mishra

->SGA stands for System Global Area.
->it store the data and control information for oracle srever.
->it can be shared by database processes.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the process of copying data from table a to table b?

0 Answers  

how to fetch common records from two tables? : Sql dba

0 Answers  

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

What is embedded sql with example?

0 Answers  

Can a procedure in a package be overloaded?

0 Answers   EXL,

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

What do you understand by case manipulation functions?

0 Answers  

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories