Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
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)?
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.comReceived on Thu Dec 06 2001 - 17:26:08 CST
![]() |
![]() |