How do I set the very large memory - VLM in windows 2K3? [message #275592] |
Mon, 22 October 2007 00:06 |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Dear all!
I have an Oracle Database in IBM server with 8GB memory?
Following the Oracle document for VLM with Windows 32bit, I changed some parameter like:
1/ Set the boot.ini file by adding :
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" [B]/3GB[/B] /noexecute=optout /fastdetect [B]/PAE[/B]
Note: Microsoft Knowledge Base article Q268363 & Q171793 to know enabling 4GB support in applications
2/ Restart Windows.
3/ Set the Oracle parameter USE_INDIRECT_DATA_BUFFERS=TRUE
4/ Set these parameters DB_BLOCK_BUFFER and DB_BLOCK_SIZE to a value.
However, with the default DB_BLOCK_BUFFER is set to 0 (My Oracle Database used SGA_TARGET), and DB_BLOCK_SIZE = 8192byte = 8MB. I have not known how are the value will I set those parameters? Please instruct me.
5/ Following the Oracle document:
Quote: |
Registry parameter AWE_WINDOW_MEMORY must be created and set in the appropriate key for your Oracle home. This parameter is specified in bytes and has a default value of 1 GB. AWE_WINDOW_MEMORY tells Oracle Database how much of its 3 GB address space to reserve for mapping in database buffers.
This memory comes from the 3 GB virtual address space in Oracle Database, so its value must be less than 3 GB. Setting this parameter to a large value has the effect of using more of the address space for buffers and using less AWE memory for buffers. However, since accessing AWE buffers is somewhat slower than accessing virtual address space buffers, Oracle recommends that you tune these parameters to be as large as possible without adversely limiting database operations.
In general, the higher AWE_WINDOW_MEMORY is set, the fewer connections and memory allocations will be possible for Oracle Database. The lower AWE_WINDOW_MEMORY is set, the lower the performance.
|
What's the AWE_WINDOW_MEMORY?
Where can I find it?
What's the value of it can I set?
6/ Following the Oracle document:
Quote: |
Once this parameter is set, Oracle Database can be started and will function exactly the same as before except that more database buffers are available to the instance. In addition, disk I/O may be reduced because more Oracle Database data blocks can be cached in the System Global Area (SGA).
Note:
Registry parameter VLM_BUFFER_MEMORY, which enabled VLM configurations in earlier releases, is not supported in Oracle Database 10g Release 1 (10.1) or later.
|
What's the parameter VLM_BUFFER_MEMORY? It belongs to Oracle or Windows?
How and where I find and set value for it?
Thank you very much!
[Updated on: Mon, 22 October 2007 00:08] Report message to a moderator
|
|
|
|
|
|