Re: PeopleSoft DBA's

We have a 15 GIG PeopleSoft installation (Financials, Inventory). One of my biggest problems is ora-1555. Rollbacks are sized appropriately ( that's really not the problem leading up to snapshot too old anyway). Its that the transaction runs too long. I have rebuilt indexes and some of the tables and we still get 1555.

The big problem with PS is that you can't optimize the SQL ( especially the COBOL SQL). Have you run into these problems, and if so, how have you dealt with them.

Mike Morgan wrote:
>
> Mitchell Loren wrote in message <37699A7B.598B883B_at_home.com>...
> >Oracle-PeopleSoft DBA's unite. All of us know what a pig PeopleSoft is
> >? But who knows how to optimize it.
> >
> >For those of you facing tuning and administrative issues related to
> >PeopleSoft on Oracle please post comments on this thread. I am suprised
> >very little is posted here.
> >
> >Today's question :
> >
> >Do you analyze your schema, and if so, how often ?
>
> We have a 60 GB PeopleSoft Financials (6.1 upgrading to 7.5) database. We
> use the CBO and analyze once a week (estimate 20%) on all tables except
> PS_PAYMENT which we analyze nightly.
>
> Mike Morgan
> American Family Insurance
> Madison, WI
Received on Fri Jun 18 1999 - 20:18:58 CDT