Subharaj, following Mark's idea, I would even say that, if you already have such a workload, use the "DB replay" functionality of Real Application Testing: - capture your workload on the production system - replay it on the test system (if needed use scale_up_multiplier to scale the query part of the workload) http://download.oracle.com/docs/cd/E11882_01/server.112/e16540/dbr_replay.htm#CHDGDCBH cheers Eric On 3 October 2011 19:51, Mark Brinsmead <pythianbrinsmead@xxxxxxxxx> wrote: > > Construct a benchmark. Run the benchmark. Observe the results. [Repeat as > needed.] > Anything else is pure guesswork. > > On Sat, Sep 24, 2011 at 2:00 AM, Subharaj Chakraborty < > Subharaj.Chakraborty@xxxxxxxxxxxxxxx> wrote: > > > Hi All, > > We are looking for a best configuration for IBM P7 server on which we are > > planning to install Oracle 11g as a database. We need to have best > > recommended configuration which should provide best performance while approx > > 600 users would be working. They will access the Oracle DB using ODAC > > through the Application server. Please suggest. > > > > Regards > > > > ________________________________ > > Disclaimer: The information contained in this message is intended only and > > solely for the addressed individual or entity indicated in this message and > > for the exclusive use of the said addressed individual or entity indicated > > in this message (or responsible for delivery of the message to such person) > > and may contain legally privileged and confidential information belonging to > > Lal Path Labs. It must not be reprinted, read, copied, disclosed, forwarded, > > distributed or used (in any manner whatsoever) by any person other than the > > addressee. Unauthorized use, disclosure or copying of the contents of this > > message is strictly prohibited and may constitute unlawful act and can > > possibly attract legal action, civil and/or criminal. The contents of this > > message need not necessarily reflect or endorse the views of Lal Path Labs > > on any subject matter. Any action taken or omitted to be taken based on this > > message is entirely at your risk and neither the originator of this message > > nor Lal P > > ath Labs takes any responsibility or liability towards the same. Opinions, > > conclusions and any other information contained in this message that do not > > relate to the official business of Lal Path Labs shall be understood as > > neither given nor endorsed by Lal Path Labs. If you have received this > > message in error, you should destroy this message and may please notify the > > sender by e-mail. Our official web site is http://www.lalpathlabs.com. > > Thank you. > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > > -- > Cheers, > -- Mark Brinsmead > Senior DBA, > The Pythian Group > http://www.pythian.com/blogs > > > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l