What is the difference between dynamic SGA and static SGA?
- 1 Answers
- 1298 Views
- MCN Solutions, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What do you mean by query string?
hi .net gurus. plz if any one has dumps on 70-631 and 70-541 on windows sharepoint services kindly mail me.
a web application needs to be created to accept the product name and quantity of a toy from a customer. After the customer has entered the product name the application needs to display the discounted price of the product to the customer (company is offering 35% discount on all products). The application should allow the customer to select the product name from a list box. and also while i'm data binding to a label with custom data binding with some declarations : "The Discounted Price is "+((System.Convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)) - ((System.convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)*0.35)). Where i need to give this declaration in asp.net 2.0.
