Home » RDBMS Server » Server Administration » about oracle memory
about oracle memory [message #568358] Thu, 11 October 2012 02:43 Go to next message
compuscience
Messages: 30
Registered: September 2012
Member
hi
i have windows server 2003 R1 SP2 on server 15 giga ram
with oracle database 9i
and both of them 32 bit
i need to know maximum memory can i assign to oracle sga
cause when i try to set it more than 1 giga
and reopen database
it will be open in idle
why?
Re: about oracle memory [message #568368 is a reply to message #568358] Thu, 11 October 2012 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No problem with 1G, as far as I remember the limit is around 1.7G.
There are some notes on Metalink/MOS about Windows memory and SGA and the use of extended memory.

Regards
Michel
Re: about oracle memory [message #568372 is a reply to message #568368] Thu, 11 October 2012 03:41 Go to previous messageGo to next message
compuscience
Messages: 30
Registered: September 2012
Member
thank you very much for your quick reply
but i ask about if you test this value for sga more than 1.7 giga
i need a document for this point


secondly i ask about pga memory
in dedicated server it will be taken from sga
or from memory

thank you very much
Re: about oracle memory [message #568375 is a reply to message #568372] Thu, 11 October 2012 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but i ask about if you test this value for sga more than 1.7 giga
i need a document for this point


As I said you will find several documents about it on MOS/Metalink.

Quote:
secondly i ask about pga memory
in dedicated server it will be taken from sga
or from memory


PGA is not part of the SGA.
Please have a look at Database Concepts

Regards
Michel
maximum memory for oracle [message #569177 is a reply to message #568358] Mon, 22 October 2012 03:32 Go to previous messageGo to next message
compuscience
Messages: 30
Registered: September 2012
Member
i need to know oracle 9i maximum sga at 16 giga ram
i mean the maximum in which above this value database dosen't open

thanks
Re: maximum memory for oracle [message #569178 is a reply to message #569177] Mon, 22 October 2012 03:39 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
If It is (approx) More than 1.7 GB.
You will get the ORA-27102: out of memory Linux Error: 12: Cannot allocate memory.

Please let us know OS version? 32 bit or 64 bit ?

-Sriram Sanka
Re: maximum memory for oracle [message #569181 is a reply to message #569177] Mon, 22 October 2012 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you think that reposting the same question than in http://www.orafaq.com/forum/m/568358/102589/#msg_568358 you will have a different answer?
Why don't you continue in the your previous topic if you have anything more to add the the previous and close question?

Regards
Michel
Re: maximum memory for oracle [message #569182 is a reply to message #569177] Mon, 22 October 2012 07:13 Go to previous messageGo to next message
John Watson
Messages: 4400
Registered: January 2010
Location: Global Village
Senior Member
I remember telling Windows administrators to set the /3GB switch in boot.ini, and then the Oracle image (SGA+PGA) can grow to 3G.

Then if they add the /PAE switch to boot.ini as well, and configure AWE (which I think was done in the registry) you can shift your database buffer cache into memory above 4G, with use_indirect_data_buffers=true and db_block_buffers=as_many_as_you_want.

That should give you a few terms to Google. Good luck.
Re: maximum memory for oracle [message #569183 is a reply to message #569182] Mon, 22 October 2012 07:17 Go to previous message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are a couple of notes on MOS describing all the steps very clearly I already told OP but had no answer.

Regards
Michel
Previous Topic: impact on table of partition truncate/delete
Next Topic: not able to print if login as sqlplus username@RMSPRD
Goto Forum:
  


Current Time: Tue Jul 29 10:40:41 CDT 2014

Total time taken to generate the page: 0.05551 seconds