Subject: PeopleSoft DBA Forum Re:PS 8.X in Oracle 10.2.0.2 Performance Issue
You need to go out to the PeopleSoft
certification page and make sure that you are follwoing the recommendations
for the init.ora parameters. Pay close attention to the recommendations
for_unnest_subquery . This one seems to solve most of the the performance
problems with 10.2.0.2.
There is a also a Red Paper for tuning
PeopleSoft on Oracle 10g. It has a lot if useful information.
You really need to do thorough testing
before you make changes to your production environment.
CONFIDENTIALITY STATEMENT. The information contained in this e-mail message, including attachments, is the confidential information of, and/or is the property of, Vanguard. The information is intended for use solely by the individual or entity named in the message. If you are not an intended recipient or you received this in error, then any review, printing, copying, or distribution of any such information is prohibited, and please notify the sender immediately by reply e-mail and then delete this e-mail from your system.