This forum is for PeopleSoft DBAs, Administrators and other interested technicians to discuss ideas, ask questions, and share information.
Membership of this group is open. You will need to create a yahoo account in order to sign up for membership of the group. Alternatively, if you don't want to join yahoo write to info@go-faster.co.uk and ask for an invitation.
Only members can post to this group. Posts from new members are moderated. Any materials of interest to PeopleSoft infrastructure technicians is valid. The group is for the benefit of the users, and we want to keep it that way. Advertising, job postings, spam and other inappropriate messages cannot be posted, and will be filtered by moderators. Authors of job adverts and other offending posts will be summarily banned from the group.
Hi SP, Thank you for the hints. I am surprised to hear that the optimizer_dynamic_sampling should be set to zero for the PPLsoft database. I am on Oracle 9,
There is a red paper on PeopleSoft site which talks "PeopleSoft Enterprise Performance on Oracle 10g Database"Â please read it .... Â BTW per this paperÂ
Willem, I was not trying to contradict your statement. As you clarified, exceptions needs to be handled in both cases. The choice to analyze full or at a
Shaji, I don't see any difference in our opinions. If your posting was meant to counter mine, then one of us wasn't clear. The only exception is in the last
I think you can usually take default sample size by using DBMS_STATS.AUTO_SAMPLE_SIZE. There might be a few tables where you need to collect statistics at a