Re: PeopleSoft DBA's

Hi

I don't agree that you cannot optimize Cobol. If the cobol statement is generated you can add a little fix (one line plus comments) in the statement generation. I remember a case in the GL edit programs where we added a first_rows that changed minutes in seconds (more than 60 times faster). You can also update the PS_SQLSTMNT (approximate name cause I don't have a PS instance at home) where some SQL statements are stored.

I also even remember a case where we had to optimize NVision. In order to minimize the changes we renamed the table and create a view with the hint embedded in it. Because it was a summary ledger, everytime the summary ledger was created we had to recreate the view. The solution was to run the NVision in batch with a pre and post processing to respectively create and remove the view.

My point is that in PS you can optimize a lot. Sometimes you don't like it but if the need is there, we should be able to do it.

Of course all these changes will have to be documented and to make sure that the DBA team and the developpers team know about this so the next upgrade they will stay in place.

Regards,

--
Pierre-André Morin

Mitchell Loren wrote:
>
> 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 Sat Jun 19 1999 - 10:18:08 CDT