Re: Oracle - Tuxedo - PeopleSoft

From: <lucasjh_at_tfn.com>
Date: Thu, 29 Apr 1999 14:33:36 GMT
Message-ID: <7g9qk0$g4h$1@nnrp1.dejanews.com>

Yes, if cpu and i/o bound, check the database wrt performance tuning. I'm not the DBA here (Unix sys admin) but from what I've seen, having the correct indexes (and I don't think they are all included "out of the box") makes a huge difference. Be sure you've applied any recommended indexes and patches from Psoft.

Also, what is the network utilization/saturation between clients and Tux server? Between Tux server and database server?

-Jeff

In article <01be87a7$21d8d820$71df4f0c_at_coes-ma>, "Steve Foley" <steve.DELETEfoley_at_worldnet.att.net> wrote:
> Is it just rebuilding the caches on the workstations? Also check the
> compresstion parameter on the appserver. I have also had some problems with
> bad indices. You can use application developer to rebuild the indices
> (alter - index). I had one SQR that ran for five hours before and 1 second
> after rebuilding.
>
> CAS&T LT05 <david.southerland_at_turner.com> wrote in article
> <37159157.3FB32F0D_at_turner.com>...
> > Hi,
> > We just upgrade our PeopleSoft application to version 7.04 using the
> > Tuxedo
> > middle teir and are being hit with bad performance problem.
> > I can see that we are IO and CPU bound on the Database server, but
> > almost
> > nothing is happening on the Tuxedo server.
> >
> > Here is our setup
> > Oracle 7.3.4.3.1 running on HPUX 10.20 K570 with 6 CPUs.
> > Tuxedo 6.3 running on HPUX 10.20 K570 with 4 CPUs.
> > I've got 6 PSAPPSRV's running
> > 28 PSQCKSRV's running
> > and 4 PSSAMSRV's running
> >
> > I have about 100 connections into the Database.
> >
> > Any Ideas out there????
> > Thanks,
> > David
> >
> >
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 29 1999 - 09:33:36 CDT