Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recommended init.ora values for PROD setup

yxes2013Feb 7 2013 — edited Feb 8 2013

Hi All,

-Assuming that I am using a 64-bit version of Oracle, 
-that there is nothing else running on the server, 
-that there will be no other databases on the server, 
-that I have substantially more data on disk than I have RAM, 
-and that I am using 11g.

I want to setup a production database 11g. The server specs is OEL 5.6 with 12Gb Ram and a Quadcore CPU.
There will be 200 users simultaneously accessing the database. I understand that 10g and 11g are "self-tuning".
So in this regard do I need to still change values in the default init.ora?

Can you give me sample PROD template of your init.ora?

Or maybe since my RAM is 12Gb I will just set the "target SGA = 8Gb" and the database will now be good?

Thanks,

Yx

Edited by: yxes2013 on 8.2.2013 16:21

Adding Justin's assumptions

This post has been answered by Karan on Feb 8 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2013

Added on Feb 7 2013

#general-database-discussions

18 comments

1,641 views