 Decide the size of every component of SGA in given case? [message #117149] |
Mon, 25 April 2005 08:18  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
What should be the percentage of every SGA Component if SGA total size is 100MB
Data base buffer
Redo buffer
Shared pool
java pool
PGA
case here is that user is only doing select on database and there are 500 user and... please let me know the reason why you decided that much % for every component of SGA (specially the size of Redo buffer)
thank you for your reply in advance... but please dont forget to send me the reason for deciding the size of every component of SGA in given above case ..
From:- Sunil
|
|
|
|
| Re: Decide the size of every component of SGA in given case? [message #117189 is a reply to message #117149] |
Mon, 25 April 2005 12:11  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
If you are using oracle 10g you can just use sga_target and let oracle figure it out for you.
Otherwise, it is best to read the concepts guide chapter on memory architecture. Understand the various components of memory and their purposes, and then understand what your particular system needs to do, and then you'll have a starting point for the values. Then tweak things over time to fine tune your guesses, using what you learn from reading the performance tuning guide.
|
|
|
|
| Re: Decide the size of every component of SGA in given case? [message #117398 is a reply to message #117189] |
Wed, 27 April 2005 00:58 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
sorry to disturb you again smartim, but this question was asked to me in my interview .. and i dont know what to say ...
case that interviewer had given me is as .... nearly 500 user are only doing select on databse (i.e. one type of query) they are not updating any record in database nor they are inserting or deleting ....AS for example you can consider that when you send *123# to your mobile connection provider to AIR TEL to know your balance money left in prepaid card you get message showing your balance money left that can be used by you...
Note:-in place of *123# it can be any code that your mobile service provider had mention for checking balance... now by sending this code to service provider we get information of our balance money in preparid card.
so now can you tell me ...any wild guess, but that with some reason
What should be the percentage of every SGA Component if SGA total size is 100MB
Data base buffer
Redo buffer
Shared pool
java pool
PGA
case here is that user is only doing select on database and there are 500 user and... please let me know the reason why you decided that much % for every component of SGA (specially the size of Redo buffer)
thank you for your reply in advance... but please dont forget to send me the reason for deciding the size of every component of SGA in given above case ..
From:- Sunil
|
|
|
|
| Re: Decide the size of every component of SGA in given case? [message #123904 is a reply to message #117149] |
Wed, 15 June 2005 08:49 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
After reading and understanding the concepts, you would realize that the interviewer did not provide enough information to answer the question, even with a good guess. For example, is the 500 users the total users on the system or the active concurrent user sessions at any one time? Are stored procedures in the database written in Java? Do users execute a very low number of distinct queries or is the number higher? Is there a lot of plsql code stored in the database? Is the size of the data involved very big or relatively small? Are there lots of indexes, or very small lookup tables? All of these factors must be taken into consideration.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
