RE: Impact of Changed O.S. on Performance

Replies inlaid in CAPITALS below:-

From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Thursday, August 17, 2006 11:15 PM To: VIVEK_SHARMA
Cc: oracle-l_at_freelists.org
Subject: Re: Impact of Changed O.S. on Performance

Vivek,

Is the application normally on a different server from the database?

YES. APPlication server is a different machine vis-à-vis the DB Server.

If they are normally separate, then using a different server for one piece won't change your result.

COULD YOU EXPLAIN PLEASE? But if they are normally on the same server, then benchmarking them on separate servers will add a network delay.

NOT Applicable.

Dennis Williams

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Thursday, August 17, 2006 1:03 PM
To: oracle-l_at_freelists.org
Subject: Impact of Changed O.S. on Performance

Qs. 1 What is the impact on Database Performance of Kernel Tuning Parameters in Solaris 10, AIX 5.3?

Scenario:-

We the Software Product Vendor need to INTERNALLY do a comparative performance benchmark between a Lower Application/Oracle Version & a Higher Application/Oracle version to check for performance gain.

Qs 2 While the customer has BOTH APP & DB Servers on SUN what would be the impact of us internally benchmarking with SUN APP Server but with AIX DB Server?

Is this approach advisable or a definite NO-NO?

NOTE - Currently a SUN DB Server is NOT available internally though it will be shortly from now.

NOTE - Any Kernel parameter Tuning for performance that we carry out on the AIX DB Server during the benchmark Runs may NOT be translatable directly to SUN at Customer Site.

Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** -- http://www.freelists.org/webpage/oracle-l