Home » RDBMS Server » Server Administration » Memory allocation between OS and Oracle
Memory allocation between OS and Oracle [message #400036] Sat, 25 April 2009 05:31 Go to next message
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

Re: Memory allocation between OS and Oracle [message #400050 is a reply to message #400036] Sat, 25 April 2009 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Memory allocation between OS and Oracle [message #400074 is a reply to message #400036] Sat, 25 April 2009 13:59 Go to previous messageGo to next message
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.
Re: Memory allocation between OS and Oracle [message #400103 is a reply to message #400074] Sun, 26 April 2009 03:48 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
yes .. 24 GB is utilizing in OS level
Re: Memory allocation between OS and Oracle [message #400164 is a reply to message #400103] Sun, 26 April 2009 18:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?



Re: Memory allocation between OS and Oracle [message #400212 is a reply to message #400164] Mon, 27 April 2009 03:13 Go to previous messageGo to next message
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..
Re: Memory allocation between OS and Oracle [message #400254 is a reply to message #400212] Mon, 27 April 2009 05:54 Go to previous messageGo to next message
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.
Re: Memory allocation between OS and Oracle [message #400542 is a reply to message #400254] Tue, 28 April 2009 12:14 Go to previous messageGo to next message
smunir362
Messages: 299
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.
Re: Memory allocation between OS and Oracle [message #400690 is a reply to message #400542] Wed, 29 April 2009 05:14 Go to previous messageGo to next message
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
Re: Memory allocation between OS and Oracle [message #403802 is a reply to message #400036] Mon, 18 May 2009 16:58 Go to previous message
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:
  


Current Time: Sat Dec 10 22:07:52 CST 2016

Total time taken to generate the page: 0.11236 seconds