Email ID Masking in PeopleSOft and step to collect stats

 Email ID Masking in PeopleSOft :

UPDATE PSUSEREMAIL SET EMAILID = '<DB_NAME>@abcd.com'; 

UPDATE PS_ROLEXLATOPR SET EMAILID = '<DB_NAME>@abcd.com'; 

UPDATE PSOPRDEFN SET EMAILID = '<DB_NAME>@abcd.com'; 

UPDATE PS_EMAIL_ADDRESSES SET EMAIL_ADDR =  '<DB_NAME>@abcd.com';

Steps to collect the stats :

2. Delete the table statistics & Collect the Table statistics with histograms for the table PS_CA_SUM_IN_USE

SQL > exec DBMS_STATS.DELETE_TABLE_STATS('<owner>','PS_CA_SUM_IN_USE');

SQL > exec DBMS_STATS.GATHER_TABLE_STATS (ownname=> <owner>, tabname=>'PS_CA_SUM_IN_USE', estimate_percent=>100, method_opt=> 'FOR ALL COLUMNS SIZE 254',DEGREE=> 6,cascade=>TRUE);

3. Execute the Batch process

4. Collect the PeopleSoft trace with same trace settings as last time and SQLT trace for the SQL CA_SUM_RFSH.ReCalc1.CalcNew.