Re: PeopleSoft DBA's

From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Fri, 18 Jun 1999 02:27:03 GMT
Message-ID: <X7ia3.54$3q.46819@ratbert.tds.net>

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 Thu Jun 17 1999 - 21:27:03 CDT