I know that there is suppose to be an increase in the amount of RAM that 3.4 uses. What I was wondering were what people were using for server specs out there and how much RAM 3.4 was taking on their server compared to 3.3. Also, how large is your dump file? The reason that I am asking is that I need to upgrade my server and I need to justify the RAM. I already know that I need to upgrade my OS.
My production 3.3 server has the following: 4 - 700 mhz processors 4 gb ram Windows NT Server Enterprise Edition I have tweaked the init.ora file. My dump file from Intralink is 1.2 gb The amount of ram allocated for the Oracle process is 1.24 gb, the over all ram is showing 1.4 gb.
My test server for 3.4 has the following: 2 - 866 mhz processors 2 gb ram Windows 2000 I have not tweaked the init.ora file except to change the optimizer mode My dump file from 3.4 is 1.2 gb The amount of ram allocated for the Oracle process, through task manager, is 338 k, but the overall ram is 1 gb on the machine and this is all that is running.
What type of increase did you see on your production server when you switched? I've heard up to 3x's. Did you notice a decrease in your test server? Could this be due to tweaking the Oracle parameters? If anyone has a similar dump file size, what are the basic specs of your server?
Brian Toussaint Sr. CAX Administrator Emerson Network Power Energy Systems North America, Inc. (630) 579-5361
These views are my own and not necessarily those of my employer.