What is the difference between dynamic SGA and static SGA?



What is the difference between dynamic SGA and static SGA?..

Answer / Dinesh Kumar Maurya

Dynamic SGA (System Global Area) and Static SGA are both memory structures used in Oracle databases. Dynamic SGA grows and shrinks as required by the database, whereas Static SGA maintains a fixed size once it has been allocated. The main difference between them lies in their memory management strategy: dynamic SGA allows for better memory usage efficiency but may lead to slower system response times due to constant resizing, while static SGA ensures predictable performance but can waste memory resources if not properly configured.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

Describe paging in asp.net?

1 Answers  


There is a login page that has two text boxes with required field validators on it. The page has a login and cancel button. How can we ensure that the click on the cancel button doesnt fire a validation event.

2 Answers   Proteans,


What r the remotable objects. and how u make an application remotable

1 Answers  


What is syntax code to send email from an asp.net application?

1 Answers  


What is the difference between control and component?

4 Answers  


Explain method to handle error using HttpError in Web API?

1 Answers  


Every Validation controls have same option ?

2 Answers   iGate,


Explain what a diffgram is, and a good use for one?

1 Answers   FT,


Suppose i create one application in vs 2008 and it is running in the latest version of IE,will it run in netscape and other browsers with low version?

2 Answers   Wipro,


How can you register a custom server control to a web page?

1 Answers  


What is reflection and disadvantages of reflection ?

2 Answers   CTC, Microsoft,


Input:http://www.allinterview.com/forms/questionform.php Output:http://www.allinterview.com/forms/questionform Write c# program to get the above desired output for the given Input.....

3 Answers   Bally Technologies,


Categories