 Which parameter? [message #123557] |
Mon, 13 June 2005 23:10  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I want to change the size of SGA in 9i & 10g can any one give me which are the parameter that i have to change in init.ora file .
I just need parameter name <----
Thank you
From:- Sunil
[Updated on: Mon, 13 June 2005 23:10] Report message to a moderator |
|
|
|
| Re: Which parameter? [message #123563 is a reply to message #123557] |
Mon, 13 June 2005 23:29  |
DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand
|
Member |
|
|
For 9i, there isn't just one parameter to set, there's a few.
On 10G, you could try setting SGA_Target to the amount of memory you want to allocate - but that'll give you a fairly average memory usage plan which may be totally unsuited to your database.
If you've already got a highly customised parameter set already then it could actually result in decreasing your system's performance.
Dougie McGibbon
[Updated on: Mon, 13 June 2005 23:30] Report message to a moderator |
|
|
|
|
|
| Re: Which parameter? [message #123574 is a reply to message #123566] |
Tue, 14 June 2005 00:40 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Sunil
For Gods' sake pls start reading some docs... everything can't be spoon fed.
Well as for ur reply, if u r unwilling to go thru docs, then my advise is .... pls-pls dont touch init.ora file. let oracle decide the sga components size on its own, on basis of default settings in default init.ora file.
...Girish
|
|
|
|
|
|
|
|
| Re: Which parameter? [message #123705 is a reply to message #123557] |
Tue, 14 June 2005 09:17 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Sunil,
I agree with others, including myself, who have said this to you. It is time for you to start reading the documentation. Start with reading the Concepts Guide. It will give you a general overview, and will point you towards further details that will answer the vast majority of your questions.
Experts have taken time to write this stuff down in the documentation so that people who are trying to learn do not have to ask. It is rude and innapropriate for you to continue to ask questions that could be easily looked up on your own.
|
|
|
|
|
|
| Re: Which parameter? [message #123903 is a reply to message #123557] |
Wed, 15 June 2005 08:45 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
As far as your first link goes, I am confused as to why you would post in this thread a question that you had already answered in another thread. But it doesn't really matter.
As far as your second link, that is an example of an ok question. You did not simply ask something that could be directly looked up in the oracle docs. A bad question would be like asking "what are the components of the sga" or "what does error ora-3113 mean". Those are factual questions that can be looked up, and you should take the time to do that.
But, your second link points to a question that does not have a straightforward answer that is applicable to all situations. Oracle is not always a math problem that is as easy as 2+2. There is often not a single correct answer but many different things that would work, especially taking into account various situations that people run.
Which is why in your second link I answered that the only way to know and be able to provide a good answer is to understand the concepts involved, and then apply those concepts to the situation at hand. There is no single right answer.
But that is enough time spent on this topic. Some of the questions you ask are ok, many are not. And I have seen you attempt to answer other people's questions in the best way you know how. So I have tried to give you the benefit of the doubt.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
i thought expert on the sites are good enough to provide me knowledge on oracle DBA very easily ... well i will read documentation and dont afraid i will not do any thing silly with init.ora ... but if i get my answer... only the name of parameter to change in init.ora for size of SGA in 9i.... that would have been a great assistance to me....