OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » about oracle memory

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

about oracle memory [message #568358]

Thu, 11 October 2012 02:43

compuscience
Messages: 97
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?

Report message to a moderator

Re: about oracle memory [message #568368 is a reply to message #568358]

Thu, 11 October 2012 03:09

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: about oracle memory [message #568372 is a reply to message #568368]

Thu, 11 October 2012 03:41

compuscience
Messages: 97
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

Report message to a moderator

Re: about oracle memory [message #568375 is a reply to message #568372]

Thu, 11 October 2012 03:56

Michel Cadot
Messages: 68641
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

Report message to a moderator

maximum memory for oracle [message #569177 is a reply to message #568358]

Mon, 22 October 2012 03:32

compuscience
Messages: 97
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

Report message to a moderator

Re: maximum memory for oracle [message #569178 is a reply to message #569177]

Mon, 22 October 2012 03:39

ramoradba
Messages: 2456
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

Report message to a moderator

Re: maximum memory for oracle [message #569181 is a reply to message #569177]

Mon, 22 October 2012 04:32

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: maximum memory for oracle [message #569182 is a reply to message #569177]

Mon, 22 October 2012 07:13

John Watson
Messages: 8929
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.

Report message to a moderator

Re: maximum memory for oracle [message #569183 is a reply to message #569182]

Mon, 22 October 2012 07:17

Michel Cadot
Messages: 68641
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 09:52:23 CDT 2024