Home » RDBMS Server » Server Administration » possible to change required Oracle10g Memory?
possible to change required Oracle10g Memory? [message #306745] Sun, 16 March 2008 09:05 Go to next message
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 #306747 is a reply to message #306745] Sun, 16 March 2008 09:10 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Perhaps I can change it to 20% of the requirement memory? Is this possible?
Reduce the size of the SGA.
Re: possible to change required Oracle10g Memory? [message #306748 is a reply to message #306747] Sun, 16 March 2008 09:14 Go to previous messageGo to next message
JazzGeek
Messages: 17
Registered: May 2007
Junior Member
Thank you for the answer.

I'm newbie to Oracle. Can you please provide a lady with instructions (from command line - my OEM doesn't work), on how to change the SGA size?

Thank you so much

Anne
Re: possible to change required Oracle10g Memory? [message #306749 is a reply to message #306745] Sun, 16 March 2008 09:21 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
start by Reading The Fine Manual http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
Re: possible to change required Oracle10g Memory? [message #306750 is a reply to message #306749] Sun, 16 March 2008 09:34 Go to previous messageGo to next message
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 #306751 is a reply to message #306745] Sun, 16 March 2008 09:42 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
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.
Re: possible to change required Oracle10g Memory? [message #306755 is a reply to message #306751] Sun, 16 March 2008 09:55 Go to previous messageGo to next message
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 #306757 is a reply to message #306745] Sun, 16 March 2008 09:59 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
If you are incapable or unwilling to use Google, then perhaps you should stick with ACCESS
Results 1 - 10 of about 13,300 for oracle change SGA
Re: possible to change required Oracle10g Memory? [message #306758 is a reply to message #306755] Sun, 16 March 2008 10:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ I think Ana already read the documentation, this is not your case
2/ Insulting seniors is not a good way to get answer and help, I think it is the opposite
3/ If you are in production, you should have at least a DBA who knows what is SGA.

I agree with Ana to don't give any more precise answer as any answer could be wrong and leads you to worst situation. It depends on your environment.
Oh! but wait, Ana already gave you the answer: reduce the SGA. If you don't understand that then you should immediatly stop the database in order to prevent any lose of data.

Another book you MUST read before administrating an Oracle database (in addition to Database Concepts Ana gave you), Administrator's Guide.

Regards
Michel
Re: possible to change required Oracle10g Memory? [message #306759 is a reply to message #306758] Sun, 16 March 2008 10:15 Go to previous messageGo to next message
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 #306761 is a reply to message #306745] Sun, 16 March 2008 10:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
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.

SQL> show sga

Total System Global Area  401743872 bytes
Fixed Size                  1300212 bytes
Variable Size             360712460 bytes
Database Buffers           33554432 bytes
Redo Buffers                6176768 bytes
SQL> 
Re: possible to change required Oracle10g Memory? [message #306763 is a reply to message #306759] Sun, 16 March 2008 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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...

Prove it.
Post what you did.
Post all SGA related parameters you have.

And stop you aggressive behaviour against those you try to help you.
Don't you see there is only one person that answers you on this Sunday and you insult him/her.
I you are not satisfied by the answer you can pick up your wallet from your pocket and call Oracle support... but you will not have an answer on Sunday.

Regards
Michel
Re: possible to change required Oracle10g Memory? [message #306765 is a reply to message #306761] Sun, 16 March 2008 11:09 Go to previous messageGo to next message
JazzGeek
Messages: 17
Registered: May 2007
Junior Member
I will do so, shortly. I have left the office but will post here what I did exactly when I get back in the office.
Re: possible to change required Oracle10g Memory? [message #306766 is a reply to message #306763] Sun, 16 March 2008 11:12 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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 #306781 is a reply to message #306761] Sun, 16 March 2008 16:52 Go to previous messageGo to next message
JazzGeek
Messages: 17
Registered: May 2007
Junior Member
You were right. I sit corrected. It worked like a charm.

Thanks for the information.

Anne
Re: possible to change required Oracle10g Memory? [message #306782 is a reply to message #306745] Sun, 16 March 2008 16:57 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
> It worked like a charm.
What did you change?

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.
Re: possible to change required Oracle10g Memory? [message #306785 is a reply to message #306782] Sun, 16 March 2008 17:22 Go to previous messageGo to next message
JazzGeek
Messages: 17
Registered: May 2007
Junior Member
Sorry, not sure what you're asking. I just changed the total SGA to a reasonable acceptable limit given how much the database is used. (It's a big production database, but doesn't require 10GB to run effectively. I changed it to 5GB and now all is well.)
Re: possible to change required Oracle10g Memory? [message #306786 is a reply to message #306745] Sun, 16 March 2008 17:41 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Which parameter(s) did you actually change?

How much RAM is in Production database server syste?

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.

[Updated on: Sun, 16 March 2008 17:43] by Moderator

Report message to a moderator

Re: possible to change required Oracle10g Memory? [message #307613 is a reply to message #306785] Wed, 19 March 2008 05:09 Go to previous messageGo to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Hii..
I am keen to see the answer?
what parameter u changed for this?
waiting for reply

Thanks
Tanad
Re: possible to change required Oracle10g Memory? [message #307790 is a reply to message #307613] Wed, 19 March 2008 21:53 Go to previous messageGo to next message
JazzGeek
Messages: 17
Registered: May 2007
Junior Member
I followed this exactly:

http://www.oracle.com/technology/pub/articles/10gdba/week17_10gdba.html
Re: possible to change required Oracle10g Memory? [message #307792 is a reply to message #306745] Wed, 19 March 2008 22:02 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: ORA-01552: cant use system rollback segment for non-system tablespace
Next Topic: oracle instance creation using dbca errors out.
Goto Forum:
  


Current Time: Sun Dec 11 04:08:08 CST 2016

Total time taken to generate the page: 0.19727 seconds