OraFAQ Forum: Server Administration » Memory allocation between OS and Oracle

Home » RDBMS Server » Server Administration » Memory allocation between OS and Oracle

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

Memory allocation between OS and Oracle [message #400036]

Sat, 25 April 2009 05:31

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Hi everyone

can anyone suggest me how to resolve below 2 issues

Issue 1
========
how to allocate upgraded memory space(24 GB) between Oracle and OS

We are using 32 bit windows 2003 XP server. Currently we have 4GB RAM.We introduced 20GB more RAM to system. But still CPU is utilising 4 GB only.Also we have done an experience as follows.

(1)Edited boot.ini file with /PAE

(2)Added a new registry under HKLM\Software\Oracle|Homex with type as RN_Z and value 1.2gb

(3)IN Oracle we changed the parameter value for USE_INIT_DATA_BUFFERS from FALSE to TRUE.

But this severely affected our Database.After changing that parameter, Database went down.Then we restarted using pfile.we cretaed a new spfile from that pfile.

Issue 2
=========
2)Second issues is that when ever I navigate different links through Database Enterprise Manager (to check performance and other activities)DB is shutting down.This started happening recently after doing all the above workouts.

Please guide me to solve the above 2 issues

please let me know if u need the pfile and spfile content

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400050 is a reply to message #400036]

Sat, 25 April 2009 09:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>We are using 32 bit windows 2003 XP server
32-bit Windoze is limited to 4 GB; which is maximum address for 32-bits.
It is simple binary math.
In order to access RAM beyond 4GB required 64-bit Windows & h/w.
If you have any issue take it up with Andy Grove & Bill Gates.
Please leave Larry Ellison & Oracle out of this discussion.

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400074 is a reply to message #400036]

Sat, 25 April 2009 13:59

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

nishantprabhakar wrote on Sat, 25 April 2009 05:31

But still CPU is utilising 4 GB only.

/PAE let you use more than 4GB in 32bit Windows ,as you said. Now you make sure 24GB is detecting at OS level .check My computer > properties . This should be the first step in troubleshooting this.

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400103 is a reply to message #400074]

Sun, 26 April 2009 03:48

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

yes .. 24 GB is utilizing in OS level

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400164 is a reply to message #400103]

Sun, 26 April 2009 18:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.acs.ilstu.edu/docs/oracle/win.101/b10113/architec.htm#i1005826

Did you set AWE_WINDOW_MEMORY appropriately?

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400212 is a reply to message #400164]

Mon, 27 April 2009 03:13

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

I was unable to find the key "AWE_WINDOW_MEMORY" . So I created a folder Homex under HKLM\Software\Oracle and inside that folder I created a new key AWE_WINDOW_MEMORY with type as REG_SZ and value as 1.2GB in bytes.

Please let me know whether im wrong anywhere..

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400254 is a reply to message #400212]

Mon, 27 April 2009 05:54

ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.

Junior Member

You cannot address 24Gb in a 32 bit OS...

It wont happen - so dont try.

If control Panel>System is reporting 24Gb it just means that the operating system has detected that there are 6*4Gb (or whatever) memory sticks in your computer...

It cant use or address them...

Upgrade to XP or Vista 64 bit if you want to use the memory - there is no other option.

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400542 is a reply to message #400254]

Tue, 28 April 2009 12:14

smunir362
Messages: 310
Registered: September 2007

Senior Member

Math of 32-bit OS is 2^32 = 4G. Means 32-bit OS can access only 4G RAM.
For using more than 4G RAM use some 64-bit OS. and then 64-bit Oracle to take full advantages of full RAM.

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #400690 is a reply to message #400542]

Wed, 29 April 2009 05:14

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I have not checked in Oracle. But remember doing in SQL server once.

There was more 8GB ram. i have enable /PAE and OS was able to detect 8GB.
Then database level , i enable AWE_MEMORY to enable Database to use 8GB

Then i limited to 7GB by setting MAX_MEMORY to 6GB.

I am not sure if similar settings are available for Oracle as well. Lil lazy to dig more Wink

Report message to a moderator

Re: Memory allocation between OS and Oracle [message #403802 is a reply to message #400036]

Mon, 18 May 2009 16:58

robregon
Messages: 1
Registered: May 2009
Location: bogotá colombia

Junior Member

Your system didn´t recognize 24GB just for the configuration of your hardware and software, its posible that your motherboard didn´t support the 24Gb directionamient or your operating system must run on 64bit

[Updated on: Mon, 18 May 2009 17:01]

Report message to a moderator

Previous Topic:	How to change partitioning (range-list) to (range)?
Next Topic:	ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:45:56 CST 2024