Which PeopleSoft tables should be to analysed for peoplesoft 8.14 on Oracle 8.17 (AIX 4.3)?

Home -> Community -> Usenet -> c.d.o.misc -> Which PeopleSoft tables should be to analysed for peoplesoft 8.14 on Oracle 8.17 (AIX 4.3)?

From: Bruce Gillespie <b.gillespie_at_patrick.com.au>
Date: Fri, 7 Dec 2001 10:26:08 +1100
Message-ID: <9uouoo$1du$1@merki.connect.com.au>

Which PeopleSoft tables should be to analysed for peoplesoft 8.14 on Oracle 8.17 (AIX 4.3)? When running PeopleSoft on Oracle 8i we experienced some performance degradation after executing analyze_schema. It appears the incorrect stats on the temporary tables cause some statements to choose the wrong execution path and take hours to run instead of minutes. To improve performance we deleted the stats from the 4200 tables we think are temporary tables. Has anybody else encountered this problem and has a solution?

Thanks.

--
Regards,

Bruce Gillespie

brucegillespie_at_bigpond.com

Received on Thu Dec 06 2001 - 17:26:08 CST