we are running ibm 260 server with 8gb of ram and 4cpu. but when i go and launch task manager i can see that oracle.exe is running and is only using 1.9 gb of memory????

But at the os level windows is detecting 8gb of memory??.

can anyone guide which parameters to be change in initbaan.ora ????

Thanks

Since you state you are using Windows 2003 I think you are running into a windows issue. I assume you are running the 32 bit version of Windows. The 32 bit version limites applications to 2gb of memory. The rest is reserved for OS.

Are you sure you see 8GB in the Task Manager. The 32 bit usually can only see a max of 4gb.

I know there is a switch you can place in the boot.ini file that will force windows to allow upto 3gb of memory for applications, but I havent tried it.

Roy

Yes i can see 8gm of memory in system properties. as i have updated the boot.ini file with the 4GT / PAE switch (in case of win2003) adn 3GB/PAE in case of win200.

But still oracle.exe is not useing more than 1.9 gb of memory.

what to do??

what happens when you do "show sga" from sqlplus?

Dave

If it is showing 1.9GB, It means on that perticular scenario. It can vary up and down depends on your SGA consumption.

You can monitor it in different scenarios may be in peak hours.

You can increase shared_pool_size to increase SGA. But it depends on your installation size.

All the best.

regards,

-Suhas