ORACLE NOT RECOGNIZING NEW RAM

pts.
Tags:
Microsoft Windows
Oracle
Oracle administration
We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size Oracle runs out of memory when I restart the database. We are running Oracle 10G R2. Is there a setting in Oracle where you declare what memory is available on ther server? I am very new to oracle so please keep your answers simple. Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

In a windows 32 bit environment one process can normally access 2G of ram, regardless of it’s being Oracle or other software. Also the Oracle windows implementation uses threads, taht is the whole DB instance is one process and thus can use normally 2G ram. However windows server can use a /3G switch in the boot.ini file to increase the process space up to 3G. See metalink 1036312.6

This is still far from your total 6G.
Another feature in windows is to use VLM (Very Large Memory) which let’s you use more ram if the program supports it. Oracle does support this feature. For more info look for the initialization parameter USE_INDIRECT_DATA_BUFFERS. See metalink 1036312.6

Good luck,
Kojak

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Elkarama
    One other solution is to switch to Windows 64bit especially if the server uses an AMD 64bit CPU.
    0 pointsBadges:
    report
  • Emersokl
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-not-recognizing-new-ram/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following