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"

Reply via email to