Payroll Issues after applying pscbo_stats
Since applying the pscbo_stats (v2 ), our payoll process ( GPPDPRUN) in UAT has either errored out or doesn't finish. It used to take <30mins prior to the implementation of the pscbo_stats on the Oracle 11g. We are on PT8.51.08, Oracle 11g R2, HCM 9.1
The 2 types of errors we are getting are :
1) Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01652
Error Message : ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP
Stored Stmt : GPPIDNT7_S_SEGDUP2
2) The following stored statment ran for 6 + hours ( and still didn't complete ) - GPPDPDM1_S_PRSDATA
The 2 types of errors we are getting are :
1) Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 01652
Error Message : ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP
Stored Stmt : GPPIDNT7_S_SEGDUP2
2) The following stored statment ran for 6 + hours ( and still didn't complete ) - GPPDPDM1_S_PRSDATA
We have tried to double our PSTEMP tablespace to 70 GB and it still errored out with the same error. In the end we
1