Actually - there is something much cooler you can do as well. Oracle 10g and higher has a feature called "Services". You can configure a service to sit in the RAC on one or multiple servers.
The service can be configured to only use up to X% e.g. 30% of server cpu/memory/whatever capacity. So - your DBA's configure a reporting service for your reporting servers. This connects to the same database but it gets it's own TNS Names entry and connect string. Your regular AR Servers connect to the normal server tns entry. This way your "real" servers can use up to 100% of the db capacity but your reporting servers can not. William Rentfrow Principal Consultant, StrataCom Inc. [email protected] Blog: www.williamrentfrow.com O 715-592-5185 C 715-410-8056 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of patchsk Sent: Monday, April 25, 2011 12:41 PM To: [email protected] Subject: Re: Architecture Question If I understand correctly you have 3 webservers, 2 app servers, 1 reporting server. This is pretty common architecture so should not cause any network clog or anything, assuming your userbase is not very excessive. As for the performance tuning there are several things to do, go through the configuration guide. At a highlevel, make sure your db and app are with in the same VLAN. router is set to fullduplex negotiation. Set the db cursor sharing to FORCE store clobs in a row On Apr 25, 8:44 am, "remedy.help" <[email protected]> wrote: > Hello All. > > We have the following setup > > ITSM 7.1/solaris/Oracle 10 g > > We have multiple web server 3 app and 2 reporting server. > > We have common DB and app servers are in server group. i have a query > "will such an architecture or set up clog on network when multiple > read/write requests are generated". > > What will be optimum setup to run a show without slowness. Also what > performance tuning we can do on DB or application. > > Any inputs are welcome with reasons, > > Regards > Amit > > ______________________________________________________________________ > _____ ____ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

