Oracle Database Discussions

Hi,

I have deployed a Windows Server 2003 (32-bit) server that has 10 GB of RAM on an Intel Xeon processor. Oracle 11g (11.1.0.7) Enterprise Edition has been installed with an instance called 'ORCL'.

I would like to dedicate 5 GB of RAM only for the Oracle DBMS service 'ORCL'.


I have tried to set VLM Configuration and did the following:

1. Added the /PAE and /3GB parameter for the MS Windows 2003 instance
2. Added priviliges under gpedit.msc to the users "Lock memory pages"
3. Added the key wanting to utilize 2 GB of 3 GB RAM for DB buffers (not sure about this if set right)
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1]
"AWE_WINODWS_MEMORY"="2147483648"


4. Altered the system parameter with the command
alter system set use_indirect_Data_buffers=true scope=spfile sid='*'
5. Changed parameters in the file
\oracle\product\11.1.0\db_1\srvm\admin\init.ora
DB_BLOCK_BUFFERS = 1073741824 (not sure about this if set right)
DB_BLOCK_SIZE = 8192 (not sure about this if set right)
shared_pool_size = 1073741824 (not sure about this if set right)

(Note: was not able to create an SPFILE from this PFILE due to a running instance with the command in SQL*Plus: Create spfile from pfile='... \init.ora')

6. When restarting the Oracle instance (service) I am getting an error message

ORA-00385: cannot enable Very Large Memory with new buffer cache parameters


I would need some advise how to configure the database service to (with parameter suggestion):

- minimize disk drive I/O (put as much into physical memory)
- size the Oracle DB service using more than 2 GB of RAM per service (expecting 4-5 GB for Oracle only)
- there will be max. 4 concurent connections/users on the Oracle DB server

Best regards,
Dejan