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
>
>
Received on Thu Apr 15 1999 - 20:20:24 CDT
