| possible to change required Oracle10g Memory? [message #306745] |
Sun, 16 March 2008 09:05  |
JazzGeek
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
HI All
I'm having serious issues with my Oracle database on my Solaris 10. When Oracle boots up it requires 40% of the machine memory. It therefore, breaks all of my other running applications because there isn't enough memory left!
Is there any way I can change the Oracle requirements for memory? Perhaps I can change it to 20% of the requirement memory? Is this possible?
Thank you!
Anne
|
|
|
|
|
|
|
|
|
|
| Re: possible to change required Oracle10g Memory? [message #306750 is a reply to message #306749] |
Sun, 16 March 2008 09:34  |
JazzGeek
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
Oh, you bet! I have that kind of time when the database won't boot right now. Here, let me tell my boss, "excuse me, please let me read this 500 page manual first before I fix the issue that has brought down the entire company."
Oh yeah, you bet. Good thinking!!!!
If you don't know how to do it, then just say so.
|
|
|
|
|
|
| Re: possible to change required Oracle10g Memory? [message #306755 is a reply to message #306751] |
Sun, 16 March 2008 09:55 |
JazzGeek
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
From: noreply@orafaq.net [mailto:noreply@orafaq.net]
Sent: Sunday, March 16, 2008 10:42 AM
Subject: New reply to Re: possible to change required Oracle10g Memory? by anacedent
Subject: Re: possible to change required Oracle10g Memory? Author: anacedent Date: Sun, 16 March 2008 07:42
Forgive me for declining to spoonfeed you the solution.
If this is in production as you imply, then you & your boss have bigger problems than just RTFM.
BTW, 40% of memory is the default for any base Oracle DB install.
If you are incapable or unwilling to use Google, then perhaps you should stick with ACCESS.
<<BTW, 40% of memory is the default for any base Oracle DB install.>>
Um, yes. That's why I'm here. Yes, everyone knows this. The question again is how can that be changed.
<<If you are incapable or unwilling to use Google, then perhaps you should stick with ACCESS.>>
Again, if you don't know the answer, then DO NOT REPLY. Sheesh, I can see you're trying to mask the fact that you don't know the answer. Fine. Go home and RTFM yourself!!
|
|
|
|
|
|
|
|
| Re: possible to change required Oracle10g Memory? [message #306759 is a reply to message #306758] |
Sun, 16 March 2008 10:15 |
JazzGeek
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
<<Oh! but wait, Ana already gave you the answer: reduce the SGA. >>
Except that is the wrong answer. I just reduced the SGA and the Oracle boot up STILL required 40% of the installed machine RAM.
SGA has nothing to do with it...
That is what Ana is doing. Ana doesn't know the answer, so says I should 'read the manual.' I think ANA should read the manual!
|
|
|
|
|
|
|
|
|
|
| Re: possible to change required Oracle10g Memory? [message #306766 is a reply to message #306763] |
Sun, 16 March 2008 11:12 |
JazzGeek
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
<<Don't you see there is only one person that answers you on this Sunday and you insult him/her.>>
I have news for you. Ana insulted me first. People do not come here to be told to "read the manual!" For goodness sakes, you know I'm right. You shouldn't defend Ana, as that behavior was very unprofessional.
People come here to get answers, not smart-ass attitude.
I'm looking for professional level help, and if you can't give it, then I'll move on elsewhere.
You're giving a bad-name to this forum.
|
|
|
|
| Re: possible to change required Oracle10g Memory? [message #306767 is a reply to message #306745] |
Sun, 16 March 2008 11:17 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>I'm looking for professional level help
Then you must be willing to pay for the advice.
With free advice, you get what you paid for it.
JazzGeek Wrote:
| Quote: |
Except that is the wrong answer. I just reduced the SGA and the Oracle boot up STILL required 40% of the installed machine RAM.
SGA has nothing to do with it...
|
ROCK<=>JazzGeek<=>HardSpot
If your proclamation is correct, then you must wait until somebody provides you a better/different solution.
For your sake, I hope you are patient; very, very patient.
The ONLY way to reduce Oracle's memory consumption significantly (from 40% to 20%) is to shrink the SGA.
HTH & YMMV!
HAND!
[Updated on: Sun, 16 March 2008 11:40] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: possible to change required Oracle10g Memory? [message #307792 is a reply to message #306745] |
Wed, 19 March 2008 22:02 |
|
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
> (It's a big production database, but doesn't require 10GB to run effectively. I changed it to 5GB and now all is well.)
>I just reduced the SGA and the Oracle boot up STILL required 40% of the installed machine RAM.
If 40% equals 10G, then your system should have 24+GB of RAM;
which is significantly more that the example in your URL.
Why are you not answering some straight forward questions?
Which parameter(s) did you actually change?
How much RAM is in Production database server system?
from the command line invoke sqlplus
log into the database then
SQL> SHOW SGA
use CUT & PASTE to post back here the complete session; what you entered & how Oracle responded.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
